When comparing Aqua Data Studio vs DBeaver, the Slant community recommends DBeaver for most people. In the question“What are the best SQL clients for Linux?” DBeaver is ranked 1st while Aqua Data Studio is ranked 11th. The most important reason people chose DBeaver is:
Supported on Windows (2000/XP/2003/Vista/7/8/10), Linux, Mac OS and Solaris (x86).
Specs
Ranked in these QuestionsQuestion Ranking
Pros
Pro Comparison tools
Pro Comprehensive list of server and database objects in GUI
Pro Query builder
Pro Rich interface as alternative for DBA queries
Show information that would require type queries with joins such as tool for object search.
Pro Import/Export data
Pro ER modeler
Pro Shortcuts for many actions for server management and security
Pro Tons of features
Pro Cross-platform
Supported on Windows (2000/XP/2003/Vista/7/8/10), Linux, Mac OS and Solaris (x86).
Pro Free
It is licensed under GPL v2.
Pro Works for many types of databases
MySQL, Oracle, PostgreSQL, IBM DB2, Microsoft SQL Server, Microsoft Access, Sybase, Java DB (Derby), Firebird (Interbase), Derby (JavaDB), SQLite, Mimer, HSQLDB, H2, IBM Informix, Teradata, SAP MAX DB, Cache, Ingres, Linter, Vertica, MongoDB, Cassandra, ODBC, Any JDBC compliant data source.
Pro Follow foreign key to their primary key
If you have a table with a foreign key you can click on it to see the table row where this key references to.
Pro Formatted text view
It has the classic grid view and a well-organized text view that you can quick-select with CTRL-A.
Pro Easy to use, clean neat inteface
Cons
Con Very expensive
Con Never-ending function errors
Like, 'Communications link failure', 'Connection refused' (Community Edition 6.2.1).
Con Cannot view function
Con Trigger edition
Until version 3.5.8 you can not edit triggers, only view (since 3.5.6).