User:Xrave
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.
Systems listed on a light purple background are no longer in active development.
General[edit]
| Product | Creator | Latest stable release date | Latest stable 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Template:Rh |Toad Data Modeler | Quest Software | 2009-03-05 | 3.3.8 | Proprietary | Yes | No | No | Yes | Yes | Yes | Yes | DB2, MS Access, Sybase | Embarcadero Delphi | |||
| Template:Rh |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 | Template:Dunno | Template:Dunno |
| Toad Data Modeler | desktop | Yes | Yes | Yes | Yes | Template:Some | Template:Some | Template:Some | Template:Some | No | Yes | Template:Dunno | Template:Dunno |
| TOra | desktop | No | Yes | Yes | No | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Template:Dunno |
Features (continued)[edit]
Legend:
- 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 | |
| Toad Data Modeler | No | Template:Dunno | 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 | Template:Dunno | |
| TOra | Template: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 | Template:Dunno |
See also[edit]
- Comparison of data modeling tools
- Comparison of object database management systems
- Comparison of object-relational database management systems
- Comparison of relational database management systems
- List of relational database management systems
- SQL programming tool
Notes[edit]
References[edit]
External links[edit]
- LINK IF I CAN DO IT