DbVisualizer

Pros: One of the best things about DbVis (apart from the fact that it just works) is that the tech support team is always super responsive. Over the years I have submitted a few support requests, and I've always had a reply within 24 hours, and that reply has always contained either a helpful explanation/instruction, or a promise to address an issue in the next release. I work with a team of about 4 developers on an Informix based project, and DbVis has always been the "go to" tool, envied by those who have no choice but to use the Informix equivalent.

Cons: In the past there were a few UI issues as Windows and Java transitioned to ultra high resolution support and inevitably Windows 11, but tech support always provided workarounds until subsequent versions addressed. There are no longer any UI issues in my experience.

Overall: Overall, I have been very happy with DbVis over the many years I have been a Pro licensee. As a developer, it's important that my "tool box" is always up to the task. I always choose to pay for tools behind which a strong and responsive support/development team stands. I am happy to pay for good quality and responsive support, and DbVis has always provided that.

Pros: I use this tool for many years now.
Easy to use, ease to configure and a lot of db’s supported.
Explain plan.
Multi tab sql editors.
Common used scripts saved inside the tool.
Connecting using SSH tunnel.
And a lot more...

Cons: Sometimes a windows size issue if you work with multiple screens with a differed resolution.

Overall: This is a very good tool for accessing databases. I can definitely recommend it to anyone who often works with databases.

Pros: Simple to use with multiple Database types. Easily export data to multiple formats. Helpful formatting of SQL for better readability.

Cons: I would like better tab organization as I tend to work on multiple projects at once.

Overall: Great tool for development and testing. Easily add new JDBC drivers for new database types and versions.

Pros: A powerful cross platform DB tool that allows both Mac and Windows users to work together seamlessly.

Cons: It would be great if we could use DBVisualizer to create and use data entry forms (beyond the Grid style data entry already supported) for in-house use.

Overall: We have used DBVisualizer for 8 years as our DB development and support tool. We have achieved DB migrations with ease that failed when using the DB specific tool. Highly recommended.

Pros: - It works on many different platforms
- Exporting data to Excel is a breeze
- Easy to use and snappy
- UI is intuitive

Cons: - Setting up connections can be complicated at first
- Learning curve for non-technical people

Overall: My team and I use this tool to perfect our queries to different DBs on various platforms. We then port these to scripts to use in our tools. DbVisualiser is an essential part of our workflow.

Pros: A deep feature set - connects to everything - and all of the features work. Handles large results well, something where many applications fall down.

Cons: It is a big application, takes a moment to start. Worth it for what it can do.

Overall: One application that connects to all the databases in my life, with working import/export features. I am an Open Source guy - but this is one application I am happy to pay a license for, there is nothing else that delivers what DbVisualizer does.

Pros: Easy to use UI.
Full featured.
Connect to multitude of data sources with ease.
Stable and reliable application.

Cons: A few aliasing issues that i imagine support will fix.

Overall: A great tool for query development and even better for manually moving data from one data source to the next.

Pros: Key Pros:
- Multi-platform use and access
- Great UI that is functional , yet easy to use
- Easy to discover schema, save schema, duplicate databases for multiple environments
- Easy to export data for reporting purposes

Cons: - Need for admin privileges to use the tool
- Setting up a new DB could be little tricky
- And queries with large result sets sometimes make the application hang and one has to restart the whole application
- Sometimes queries are very difficult to stop

Overall: DbVisualizer is the goto tool for me and my team to access DBs across multiple platforms without having to switch tools. As an organization that uses DBs from different vendors, this is a must have for us. Our ETL and SAS teams use the tool for querying the DB and for data analysis. The macro-tool is super useful when it comes to ETL type work. I know members of my team who use this tool multiple times a day. It is indispensable.

Pros: Connection management, wide DBMS platform support, query parameterization, query history, multiple export formats, CLI functionality, object management, query timing, environment customization.

Cons: TBH there's so much to like that I have a hard time finding things to criticize. I use this tool every single day and have yet to run into something I need to do that it doesn't support. The only issues I've run into are JVM-related and occur with OOM exceptions, but that has only happened after I've had a long-running instance of DbVis and have returned large result sets. Easily resolved by the occasional restart.

Overall: I've used DbVis daily for over 10 years for multiple platforms (Oracle, SQLServer, Postgres, Netezza, and Vertica). I've tried many other paid and free tools, and one of them really compare at this price point. It does everything I need and continues to be improved year over year.

Pros: Responsive application, intuitive UI, auto format SQL. Application is highly customizable, even things like the auto-formatting of SQL code feature is customizable to fit your preferred formatting.

Cons: Not a lot of new features. Would love to see integrations to automation tools like Power Automate Desktop. Would also like to see a way of saving queries in more of a library format than the standard saving of SQL files.

Overall: I moved from a MS SQL Server environment to an IBM DB2 environment and found the out-of-the-box toolset to be lacking significantly. Adding DBVis dramatically improved the ease of working with databases.

Pros: DBViz has been my sql tool of choice for the past 3-4 years. I used the free version for a couple of years and now have upgraded to the pro version. Very easy to configure and use.

Cons: Only 1 window at a time unless you have the pro version.

Overall: Other folks in the company use other tools that I found a little more difficult to use. I recommend to everyone that uses an SQL tool.

Pros: Options - support for a number of database management systems in one tool. Unlike some of the alternatives, there is actual support behind these claims.

Ease of Install - You can pull down a combined installer that handle JVM dependencies - making the install a breeze. Especially useful when rolling out to non-developers.

Features - DbVisualizer comes standard with everything you need to work with modern databases. Query support, schema discovery and object scripting. Great visual queues when working across non-prod and production environments.

Cons: Driver management can be a little tedious at times, but it still beats building out JDBC connections in a text file by a mile.

Overall: I first started using DbVisulaizer years ago when searching for a replacement for Toad at a SaaS startup in Mountain View. We were looking to lower some of our operational costs around the management of our Oracle investments. As time progressed, the team began working with PostgreSQL, SQL Server, MySQL and Cassandra. The selection of DbVisulaizer to replace an Oracle centric tool for us became a great universal investment.

Pros: - Connectivity - Support for various databases
- Very detailed database specific functionality
- Ease-of-use

Cons: - It would be great, if DbVisualizer would be available as a Web UI

Overall: Overall DBVisualizer is a really advanced and robust SQL editor offering all the functionality you need as a SQL developer and DBA.

Pros: - Inline Cell Editing for fast Db fixes is our most used feature
- Works with latest Mac Chips (M1/M2)
- Easy to use in the daily workflow

Cons: - With SQL Server i have sometimes problems with newest features in T-SQL Programming. But in my case i only use this very rare.

Overall: Highly recommended for professional use and has been in use in our company for years with complete satisfaction.

Pros: * Can handle all types of databases
* Easy and intuitive to use
* SQL editor with code completion
* Manage Scripts
* Directly edit data in the UI

Cons: I have no cons to mention here. At least we have no use-cases the toll doesn't support for now.

Overall: As we from IT are dealing with/supporting different software-systems with their underlying different database systems, DbVisualizer is a must-have for us. DbVisualizer is the swiss knife and rules all types of databases.

Pros: The product is not OS dependent.
Graphic Query Builder help to build powerful query without SQL knowledge.

Cons: At that time I do not see any cons. The product is just perfect if you need to work in a multi OS environment within your organization.

Overall: Many of my students works with Windows OS or Mac OS and can work with this product the same way.
They do not have to learn SQL for building queries.

Pros: Easy to manage and fast to connect and start working.
It helps a lot when we have to connect and manage different RDBMS, not only to manage structures but also data.

Cons: Couldn't find one. It helps a lot when we have to connect and manage different RDBMS, not only to manage structures but also data.

Overall: It helps a lot when we have to connect and manage different RDBMS, not only to manage structures but also data.

Pros: I really like the integration with the database system (Mimer SQL in my case). Every possible SQL command is available via menus. Excellent for seldom used statements.
Error handling is really clear and to the point.
Nice explain plan integration gives a good overview of what happens with an SQL statement.

Cons: Setting up your first connection is still difficult (although better than some versions back). In particular I find Ping Server button confusing because yu have filled in everything on how to connect with the database server. But ping only checks if the machine is alive, rather than my database connection settings which would be more useful.
DbVisualizer is slow to start up.

Overall: DbVisualizer handles every aspect of database integration. From loading data, checking and developing SQL statements from both a functional and performance point of view. The fact that you continue with your previous session every time you run is really useful and improves productivity. For the (very) advanced database user it is also possible to extend DbVisualizer with new functionality. This is straightforward and fun.

Pros: Ease of use and the ability to hit different databases is really a plus. I also really appreciate the SQL History item - very helpful. Cross platform doesn't have a different user experience.

Cons: Really can't think of anything, I've assisted a number of fairly non-tech users in setting up and running and while it may feel a bit overwhelming, it really has not been an issue.

Overall: My department has been using this product for a number of years, the overall cost, ease of use, and great documentation are excellent. The ability to use the free version before diving into pro is also really great.

Pros: Ease of use along with a plethora of customizable options makes for an amazing tool. Worth the price.

Cons: While the plethora of options can sometimes cause analysis paralysis.

Overall: How easy it is to navigate the data through entities (tables) and display a graphic representation of the relations. I haven't seen this feature in any other DB admin software.