The following tables compare general and technical information for a number of available database administrator tools. Please see individual product articles for further information. This article is neither all-inclusive nor necessarily up to date.
General[edit]
Product | Creator | Latest stable release date | Latest stable release | Latest testing release | License | Runs on Windows | Runs on Mac OS X | Runs on Linux | Oracle | MySQL | PostgreSQL | MS SQL Server | ODBC | JDBC | SQLite | Other | Programming language |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Adminer | Jakub Vrána | 2019-01-24 | 4.7.1[1] | none distributed | Apache License or GPL | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | PHP | |||
DaDaBIK | Eugenio Tacchini | 2012-04-03 | 4.4 | ? | Proprietary | Yes | Yes | Yes | Yes | Yes | Yes | Yes | No | No | Yes | PHP | |
Database Deployment Manager | The Unauthorized Frog project | 2012-05-29 | v0.1i | ? | LGPL | Yes | No | Yes | Yes | Qt/C++ | |||||||
DatabaseSpy | Altova | 2013-06-12 | v2013r2sp1 | ? | Proprietary | Yes | No | No | Yes | Yes | Yes | Yes | Yes | Yes | IBM DB2, Sybase, MS Access | C++ | |
Database Workbench | Upscene Productions | 2017-06-29 | 5.3.2 | ? | Proprietary | Yes | requires Wine | requires Wine | Yes | Yes | Yes | Yes | InterBase, Firebird, SQL Anywhere, NexusDB and MariaDB | Delphi | |||
DataGrip | JetBrains | 2017-09-06 | 2017.2.2 | 2017.3 RC, build 173.3727.95 | Proprietary | Yes | Yes | Yes | Yes | Yes | Yes | Yes | No | Yes | Yes | Sybase, DB2, H2, Hypersonic SQL, Amazon Redshift, Apache Derby | Java |
DBeaver | Serge Rider | 2019-03-10 | 6.0 | ? | Apache License | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | MySQL, PostgreSQL, Oracle, EXASOL, IBM DB2, SQL Server, Apache Derby, Firebird all with JDBC driver | Java |
DBEdit | Jef Van Den Ouweland | 2011-03-18 | 2.4 | ? | GPL | Yes | Yes | Yes | Yes | Yes | Yes | Yes | No | Yes | Yes | IBM DB2, HSQLDB, Apache Derby, H2 | Java |
Epictetus | Antilogic Software | ? | ? | 1.0 (2009-06-17) | Proprietary | Yes | Yes | Yes | Yes | Yes | Yes | Sybase, InterBase/Firebird, H2, HSQLDB | Java | ||||
ER/Builder Data Modeler | SoftBuilder | 2018-10-15 | 1.0 | ? | Freeware | Yes | No | No | Yes | Yes | Yes | Yes | Yes | Firebird and MariaDB | |||
HeidiSQL | Ansgar Becker | 2017-12-19 | 9.5 | ? | GPL | Yes | requires Wine | requires Wine | Yes | Yes | Yes | Embarcadero Delphi | |||||
Maatkit | Baron Schwartz | 2010-06-01 | 5247 | discontinued since 2011 | GPL | Yes | Yes | Yes | Yes | Perl | |||||||
Microsoft SQL Server Management Studio | Microsoft | 2018-05-9[2] | 17.7 | ? | Proprietary | Yes | No | No | Yes | including SSAS management, and MDX, DMX, and XMLA languages | .Net | ||||||
ModelRight | ModelRight | ? | 3.6 | 3.7 | Proprietary | Yes | No | No | Yes | Yes | Yes | Yes | SQL Server, Oracle, MySQL, PostgreSQL, DB2, DB2/zOS, MS Access | C++ | |||
MySQL Workbench | Oracle Corporation | 2017-02-07 | 6.3.9 | ? | Community Ed: GPL Standard Ed: Commercial Proprietary | Yes | Yes | Yes | Yes | C++/C#Objective-CPython (programming language) | |||||||
Navicat | PremiumSoft CyberTech Ltd. | 2018-07-26 | 12.1 | ? | Proprietary | Yes | Yes | requires Wine | Yes | Yes | Yes | Yes | Yes | Yes | |||
Navicat Data Modeler | PremiumSoft CyberTech Ltd. | 2015-12-10 | 2.1 | ? | Proprietary | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | |||
Oracle Enterprise Manager | Oracle Corp. | 2015-06-16 | 12.1.0.5 | ? | Proprietary | Yes | No | Yes | Yes | Yes | Yes | DB2, Sybase, TimesTen | Java | ||||
Oracle SQL Developer | Oracle Corp. | 2018-04-05 | 18.1.0.095.1630 | ? | Proprietary | Yes | Yes | Yes | Yes | Yes | No | Yes | Yes | Yes | Microsoft Access, Sybase, DB2, Teradata | Java | |
Orbada | Andrzej Kaluza | 2014-08-13 | 1.2.2.335 | none | GPL | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Firebird, HSQL, InterBase, Derby all with JDBC driver | Java |
pgAdmin III | pgAdmin Development Team | 2012-09-11 | 1.22.2 | ? | PostgreSQL License | Yes | Yes | Yes | Yes | C++ | |||||||
phpLiteAdmin | Dane Iracleous | 2016-12-14 | 1.9.7.1[3] | ? | GPL | Yes | Yes | Yes | No | No | No | No | No | No | Yes | PHP | |
phpMyAdmin | phpMyAdmin Development Team | 2019-01-26[±] | 4.8.5[4] | none | GPL | Yes | Yes | Yes | Yes | Drizzle, MariaDB | php | ||||||
SQL Database Studio | Jan Prochazka | 2016-05-27 | 3.4.1 | Proprietary | Yes | No | No | No | No | No | Yes | .NET, WPF, C# | |||||
SQLyog | Webyog Softworks Pvt. Ltd. | 2017-06-14 | 12.4.3[5] | ? | GPLv2 | Yes | requires Wine | requires Wine | Yes | C++ | |||||||
SQuirreL SQL | Colin Bell, Gerd Wagner, Rob Manning and others | 2017-12-29 | 3.8.1 | GPLv2 & LGPLv2 | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Access,Axion Java RDBMS, Apache Derby, Daffodil DB, FileMaker (JDBC), Fujitsu Siemens SESAM/SQL, Firebird, FrontBase, HSQLDB, Hypersonic SQL, H2 (DBMS), IBM DB2, Informix, Ingres, OpenIngres, InstantDB, InterBase, Mckoi SQL Database, Microsoft SQL Server, Mimer SQL, Netezza, Pointbase, SAPDB, Sybase, Sunopsis XML Driver, Teradata Warehouse, ThinkSQL RDBMS, Vertica Analytic Database, and others with JDBC drivers. | Java | |
Toad | Quest Software | Various | Various | Betas | Proprietary | Yes | No | No | Yes | Yes | Yes | Yes | DB2, Sybase | Embarcadero Delphi, C#.NET | |||
Toad Data Modeler | Quest Software | 2009-03-05 | 3.3.8 | Betas[6] | Proprietary | Yes | No | No | Yes | Yes | Yes | Yes | DB2, MS Access, Sybase | Embarcadero Delphi | |||
TOra | Community | 2017-07-04 | 3.2 | ? | GPL | Yes | Yes | Yes | Yes | Yes | Yes | Teradata | C++/Qt |
Features[edit]
Legend
- Create/alter table:
- Yes - can create table, alter its definition and data, and add new rows
- Some - can only create/alter table definition, not data
- Browse table:
- Yes - can browse table definition and data
- Some - can only browse table definition
- Multi-server support:
- Yes - can manage from the same window/session multiple servers
- Some - can manage from a different window/session multiple servers
- Monitoring server:
- Yes - includes a headless server, that runs checks and reports failures
Tools | User Interface | Create & Alter wizard | Browse | Auto Completion | Syntax colored | Multi server support | Monitoring server | ||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Database | Table | Procedure | Trigger | Database | Table | Procedure | Trigger | ||||||
Adminer | Browser-based | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | No | Yes | ? | ? |
Altova DatabaseSpy | desktop | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | ? |
DaDaBIK | Browser-based | No | Some[note 1] | No | No | No | Some[note 2] | No | No | No | No | No | ? |
Database Deployment Manager | desktop | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | No | ? |
Database Workbench | desktop | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | ? |
DataGrip | desktop | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | No |
DBeaver | desktop | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | ? |
DBEdit | desktop | No | No | No | No | Yes | Yes | Yes | No | No | Yes | No | ? |
Epictetus | desktop | No | Yes | No | No | Yes | Yes | Yes | Yes | Yes | Yes | ? | ? |
ER/Builder Data Modeler | desktop | Yes | Yes | Yes | Yes | Some | Some | Some | Some | No | Yes | ? | ? |
Microsoft SQL Server Management Studio | desktop | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | No |
ModelRight | desktop | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | No | Yes | ? | ? |
MySQL Workbench | desktop | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Some |
Navicat | desktop | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | ? |
Navicat Data Modeler | desktop | No | Yes | No | Yes | No | No | No | No | Yes | Yes | Yes | ? |
Oracle Enterprise Manager | Browser-based | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | ? | Yes |
Oracle SQL Developer | desktop | No | Yes | Yes | Yes | Yes | Yes | Yes | Yes | No | Yes | Yes | ? |
Orbada | desktop | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | No |
pgAdmin III | TDI | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Some |
phpLiteAdmin | Browser-based | Yes | Yes | No | Yes | Yes | Yes | No | Yes | No | No | ? | ? |
phpMyAdmin | Browser-based | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
SQL Database Studio | desktop | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | No |
SQLyog | desktop | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | ? | ? |
SQuirreL SQL | desktop | ? | ? | ? | ? | Yes | Yes | ? | ? | Yes | Yes | Some | ? |
Toad | desktop | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | ? | ? |
Toad Data Modeler | desktop | Yes | Yes | Yes | Yes | Some | Some | Some | Some | No | Yes | ? | ? |
TOra | desktop | No | Yes | Yes | No | Yes | Yes | Yes | Yes | Yes | Yes | Yes | ? |
Features (continued)[edit]
Legend: The next karate kid dvd kopen.
- User manager:
- Yes - user manager with support for database and schema permissions as well as for individual object (table, view, functions) permissions
- Some - simple user manager with support for database and schema permissions
- No - no user manager, or read-only user manager
user manager | Plugin | Compare | Import | Export | Debugger | Source control | Spatial Visualization | |
---|---|---|---|---|---|---|---|---|
Adminer | Yes | Yes | Yes | SQL script, CSV, TSV or the above in zip (as a plugin); imports of server-site file in SQL or SQL in zip, gzip or bzip2 | SQL script, CSV, TSV or the above in zip, gzip, bzip2; XML (as a plugin) | No | Git | |
Altova DatabaseSpy | No | No | Yes | CSV, XML | XML, XML Structure, CSV, HTML, MS Excel | No | ? | |
DaDaBIK | Some[7] | No | No | No | CSV | Yes | No | |
Database Workbench | Yes | No | Yes | Yes | Yes | Yes | ? | |
DataGrip | No | Yes | Yes | Yes | TXT, CSV, HTML, XML, DBF, SQL script, RTF, MS Word, MS Excel, MS Access, MS Windows Clipboard, Paradox file, WK1, WQ1, SLK, DIF, LDIF | No | Yes | |
DBeaver | Yes | Yes | Yes | Yes | Yes | No | With Eclipse plugins | |
DBEdit | No | No | No | No | MS Excel, PDF, Text, SQL script | No | ? | |
Epictetus | No | Yes | No | No | Excel | No | ? | |
ER/Builder Data Modeler | No | No | No | Yes - from MySQL, MariaDB, FireBird and PostgreSQL databases | Yes - Export DDL SQL and databases (MySQL, MariaDB, FireBird, SQLite and PostgreSQL) | No | No | |
ModelRight | Some | Yes | Yes | Yes - from supported databases using native interfaces, or from any ODBC source | SQL; XML; DTD; Diagram as BMP, JPEG | No | ? | |
Navicat | Yes | No | Yes | Yes - TXT, CSV, DBF, HTML, MS Excel, MS Access, Paradox file, WK1, WQ1, XML, or from any ODBC source (See link for limitations[8]) | Yes - TXT, CSV, HTML, XML, DBF, SQL script, RTF, MS Word, MS Excel, MS Access, MS Windows Clipboard, Paradox file, WK1, WQ1, SLK, DIF, LDIF (See link for limitations[8]) | Yes | No | |
Navicat Data Modeler | No | No | Yes | Yes - Import Database from server/ODBC | Yes - Export SQL | No | No | |
MySQL Workbench | Yes | Yes | Yes | Yes - CSV, HTML, JSON, MS Excel, SQL INSERTS, Tab-separated, XML | Yes - CSV, HTML, JSON, MS Excel, SQL INSERTS, Tab-separated, XML | Yes | No | |
Oracle SQL Developer | Yes | ? | ? | Yes | Yes | Yes | ? | |
Orbada | No | Yes | Yes | SQL script | SQL script, CSV, XML, HTML, PDF, Excel, DBF, DataText | No | No | |
pgAdmin III | Yes | Yes | No | CSV, Text, or binary | CSV, text, HTML, XML | Yes | No | |
phpMyAdmin | Yes | Some | Yes | Yes - CSV, SQL, XML, Excel, ODS | Yes - CSV, LaTeX, Excel, Word, ODS, ODT, XML, SQL, YAML, Texy!, JSON, NHibernate, PHP, PDF, MediaWiki | Yes | Git | |
SQL Database Studio | Yes | Yes | No | CSV, XML, MS Excel | CSV, HTML, MS Excel, SQL INSERTS, Tab-separated, XML | No | No | |
SQLyog | Yes | ? | Yes | Yes | Yes | ? | ? | |
SQL Server Management Studio | Yes | Yes | ? | Yes | Yes | Yes | Yes[9] | Yes |
SQuirreL SQL | ? | Yes | Yes | Yes | ? | No | ? | |
Toad | Some | No | Yes | Yes | Yes | Yes | SVN, CVS, TFS, VSS | |
Toad Data Modeler | No | ? | Yes | Toad for Oracle ERD, ERWin 7.1(XML) via plugin | SQL; meta data in XML; report in HTML/RTF/CSV; diagram as BMP, JPEG, PNG | No | ? | |
TOra | Some | No | Yes | Yes | Yes | Yes | No |
Features - visual design and reverse engineering[edit]
Legend:
- Visual schema/E-R design: the ability to draw entity-relationship diagrams for the database. If missing, the following two features will also be missing
- Reverse engineering - the ability to produce an ER diagram from a database, complete with foreign key relationships
- Yes - supports incremental reverse engineering, preserving user modifications to the diagram and importing only changes from the database
- Some - can only reverse engineer the entire database at once and drops any user modifications to the diagram (can't 'refresh' the diagram to match the database)
- Forward engineering - the ability to update the database schema with changes made to its entities and relationships via the ER diagram visual designer
- Yes - can update user-selected entities
- Some - can only update the entire database at once
Visual query builder | Visual schema/model/E-R diagram design | Reverse engineering | Forward engineering | ER diagram groupboxes | |
---|---|---|---|---|---|
Adminer | Yes | Yes | Yes | No | No |
Altova DatabaseSpy | Yes | Yes | Yes | Yes | ? |
DaDaBIK | Some[note 3] | No | No | No | No |
Database Deployment Manager | Yes | Yes | Yes | No | No |
Database Workbench | Yes | Yes | Yes | ? | Yes |
DBeaver | No | Yes | Yes | No | ? |
DBEdit | No | No | No | No | No |
ER/Builder Data Modeler | No | Yes | Yes | Yes | No |
ModelRight | No | Yes | Yes | Yes | Yes |
Navicat | Yes | Yes | Yes | Yes | Yes |
Navicat Data Modeler | Yes | Yes | Yes | Yes | Yes |
MySQL Workbench | Yes | Yes | Yes | Yes | Yes |
Oracle SQL Developer | Yes | Yes | Yes | Yes | ? |
Orbada | No | No | No | No | No |
pgAdmin III | Yes | No | No | No | No |
phpMyAdmin | Yes | Yes | Yes | No | No |
SQL Database Studio | Yes | Yes | Yes | Yes | No |
SQL Server Management Studio | ? | Yes | Yes | ? | ? |
SQLyog | Yes[10] | Yes[11] | Yes | Yes | ? |
SQuirreL SQL | Yes | Yes | Yes[note 4] | ? | No |
Toad | Yes | Yes | Yes | Yes | ? |
Toad Data Modeler | No | Yes | Yes | Yes[note 5] | ? |
See also[edit]
Notes[edit]
- ^create CRUD interfaces, so create table data, not table theriselves.
- ^Browse table data, not table definitions.
- ^The CRUD interface created includes a search form.
- ^Only incremental, by manually going through each table and clicking 'Add to graph'.
- ^Generated SQL must be executed outside Toad Data Modeler.
References[edit]
- ^https://www.adminer.org/
- ^'Download SQL Server Management Studio (SSMS)'. 9 May 2018. Archived from the original on 14 May 2018.
- ^https://bitbucket.org/phpliteadmin/public/downloads
- ^'Security fix: phpMyAdmin 4.8.5 is released'. phpmyadmin.net. Retrieved 2019-01-26.
- ^'blog.webyog.com/sqlyog-mysql-gui-12-4-3-released/'. Webyog.
- ^Toad Data Modeler Betas
- ^can manage its own users, which override the DBMS users
- ^ abtitle= Navicat feature matrix
- ^https://blogs.technet.microsoft.com/dataplatforminsider/2016/11/21/source-control-in-sql-server-management-studio-ssms/
- ^SQLYog query builder
- ^SQLYog schema designer
External links[edit]
Possible Duplicate:
Free Tool to compare Sql Server tables
Free Database Comparison Tool
I would like to compare two SQL Server databases including schema (table structure) and data in tables too. What is best tool to do this?
marked as duplicate by John Palmer, stusmith, Praveen Kumar Purushothaman, C.Evenhuis, user13673Nov 29 '12 at 0:55
This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.
15 Answers
Beyblade burst app apk download. I am using Red-Gate's software: http://www.red-gate.com
Database Comparison Tools
I use schema and data comparison functionality built into the latest version Microsoft Visual Studio 2015 Community Edition (Free) or Professional / Premium / Ultimate edition. Works like a charm!
Red-Gate's SQL data comparison tool is my second alternative:
(source: spaanjaars.com)
I like Open DBDiff.Updated Open DBDiff Link
It's not the most complete tool, but it works great and it's free. And it's very easy to use.
SQL Admin Studio from http://www.simego.com/Products/SQL-Admin-Studio is now free, lets you manage your SQL Database, SQL Compare and Synchronise, Data Compare and Synchronise and much more. Also supports SQL Azure and some MySQL Support too.
[UPDATE: Yes I am the Author of the above program, as it's now Free I just wanted to Share it with the community]
I'm partial to AdeptSQL. It's clean and intuitive and it DOESN'T have the one feature that scares the hell out of me on a lot of similar programs. One giant button that it you push it will automatically synchronize EVERYTHING without so much as a by-your-leave. If you want to sync the changes you have to do it yourself and I like that.
There is one tool with source code available at http://www.codeproject.com/Articles/205011/SQL-Server-Database-Comparison-Tool
That should give flexibility as code is available.
dbghost is the best i have used to date. one of the best features i have seen is that it will generate SQL code to go between versions of a database based on the SQL you keep in source control, as well as a database. simple and easy to use.
I've used SQL Delta before (http://www.sqldelta.com/), it's really good. Not free however, not sure how prices compare to Red-Gates
Try DBComparer, it's free and fast:
Database Workbench can made it too
Cross database development
Use the Schema Compare and Migration Tools to compare testing and deployed databases, migrate existing databases to different database systems.
you can also made it with database Comparer
I use it for Firebird and it works well.
Try dbForge Data Compare for SQL Server. It can compare and sync any databases, even very large ones. Quick, easy, always delivers a correct result.Try it on your database and comment upon the product.
We can recommend you a reliable SQL comparison tool that offer 3 time’s faster comparison and synchronization of table data in your SQL Server databases. It's dbForge Data Compare for SQL Server and dbForge Schema Compare for SQL Server
Main advantages:
- Speedier comparison and synchronization of large databases
- Support of native SQL Server backups
- Custom mapping of tables, columns, and schemas
- Multiple options to tune your comparison and synchronization
- Generating comparison and synchronization reports
Plus free 30-day trial and risk-free purchase with 30-day money back guarantee.
We are using an inhouse developed solution that is basicly a procedure with arguments of what you want included in the comparision (SP's, Full SP code, table structure, defaults, indices, triggers. etc)
Depending on your needs and budget, it might be a good way to go for you as well.
It is quite easily developed as well, then we just redirect output of procedure to textfiles and do text comparisions between the files.
One good thing about it is that its possible to save the output in source control.
/B
I've used Red Gate's tools and they are superb.However, if you can't spend any money you could try Open DBDiff to compare schemas.
I would definitely go with AdeptSQL if you're using MSSQL. It's the least good looking but the most talented db compare tool amongst the ones I've tried. It can compare both the structure and the data. It tells you which tables exist on one db but does not exist on the other, compares the structure and data of the common ones and it can produce the script to synchronize the two. It's not free but has a 30 day trial (as far as I can remember)
I tried OpenDiff Tool . Great tool that is free and easy to use .
![Database comparison tools Database comparison tools](https://image.slidesharecdn.com/slidesharefinaldecisiongraphdb19-150128071238-conversion-gate01/95/orientdb-vs-neo4j-comparison-of-queryspeedfunctionality-8-638.jpg?cb=1422444888)
Not the answer you're looking for? Browse other questions tagged sqlsql-serverdatabasecompare or ask your own question.
A database comparison tool for Microsoft SQL Server 2005+ that reports schema differences and creates a synchronization script.
Open DBDiff can synchronize
- Tables (including Table Options like vardecimal, text in row, etc.)
- Columns (including Computed Columns, XML options, Identities, etc.)
- Constraints
- Indexes (and XML Indexes)
- XML Schemas
- Table Types
- User Data Types (UDT)
- CLR Objects (Assemblies, CLR-UDT, CLR-Store Procedure, CLR-Triggers)
- Triggers (including DDL Triggers)
- Synonyms
- Schemas
- File groups
- Views
- Functions
- Store Procedures
- Partition Functions/Schemes
- Users
- Roles
Icons provided from http://www.fatcow.com/free-icons under under a Creative Commons Attribution 3.0 License.