DbVisualizer

"Powerful, flexible & verstile"

Kommentarer: Since 2015, I've been using DbVisualizer in order to work, primarily, with Salesforce. Since then I've also used it with Sqlite3, PostgreSQL, MS SqlServer and others. The Pro version is especially handy due to having the ability to open as many SQL (and other) windows as necessary. Once I used the macro abilities for ETL type of work and found that to be easier than expected. Overall, a solid, worthwhile tool.

Fördelar: Interfaces with any database I've attempted to use.
Extremely useful with Salesforce (assuming availability of an appropriate JDBC driver)
Easy to discover schema, save schema, duplicate databases for multiple environments
Shows all data in a specified table
Data exportable and importable as CSV

Nackdelar: Sometimes, setting up a new database connection can be a little tricky. Admin must know the options.

"One of my "Must Have" Tools"

Fördelar: I've been using DBVis for about as long as it's been around. I recall using it back around 1999. This product has continued to evolve and improve, which is why I continue to subscribe to annual updates. The greatest benefit I've gotten from the app is a single platform providing access to any data source having a JDBC driver (which is probably near all of them) and that exposes those differing systems in a common and consistent way. There is absolutely no noticeable lag or buffering or constant cache updates like I see with another product.

Nackdelar: Prior to about 2017 I'd have very little to say here. Around that time I began using a programming editor, JetBrains IntelliJ Ultimate. Part of that software is their full DataGrip application. Somehow, they've got the edge when it comes to code completion and object introspection. The responsiveness within the UI is so much quicker and smoother than when I enable auto-completion in DbVis.

"DB Visualizer"

Kommentarer: Excellent; Support is first rate and the online manual supplies practical examples for scripting or the use of variables.

Fördelar: Ability to connect to almost any ODBC/JDBC compliant data emgine. Ease of using either tabs or multiple SQL statements in a single tab. Ability to import data from desktop to remote data store. Ability to do an explain/execution plan ( if db engine supports functionality) and get a relative idea of data paths for a query.

Nackdelar: Lack of "find/attribute help" when writing a query or SQL statement. Many tools provide "bubble help" of attributes as you type.

"Fullt functional multi-platform database client"

Kommentarer: Overall DbVisualizer has become a staple in my toolbox because I am able to access different platform databases without having to switch between the vendor-provided tools. It has many of the features that I need and would gain by using the other tools.

Fördelar: The ability to connect to a database-independent of platform from a single tool is the biggest reason for my use of DbVisualizer. The tool provides a single tool that can query or inspect the database structure.

Nackdelar: There is not much to dislike about the tool, but it would be nice to have the option to export to Excel. The export feature is something that I do use regularly and being able to get data into Excel for business users to consume would be helpful.

"Long time users review"

Kommentarer: Very helpful on my day to day usage as java backend developer. A lot more features the small IDE plugins for DB access.

Fördelar: The functionality, at least of the Pro version, is absolutely fantastic for me as Java developer mainly for backends and data persistency layers. The huge number of supported databases matches with every of my project requirements in the past. The ability to export (part of) tables and whole databases into SQL and a few other formats was very helpful. The content assistent of the SQL editor reduce the need for writing all those verbose table and column names by hand.

Nackdelar: Sometimes it is hard to find the right option within the preferences for a given feature.
And queries with large result sets sometimes make the application hang and one has to restart the whole application. But afterwards it's possible to decrement the max result size and run the query again.
The content assistent could learn more about the current scope in order to provide more options for auto text completion.