| | Free Edition | Ultimate Edition |
| Reverse engineering |
Connect to a growing list of JDBC compatible databases, including Oracle, MySQL, PostgreSQL, DB2 for
Windows/Linux, Cache, DaffodilDB, FrontBase, HSQLDB, Informix, JavaDB/Derby, Microsoft SQL Server,
Mimer, Pervasive, PointBase, Sybase SQL Anywhere, Sybase ASE.
|
 |
|
|
Import schema with tables, foreign keys, procedures, triggers, sequences, and more.
|
 |
|
|
Save imported schema as XML files in a database independent format.
|
|
|
|
Edit the database specific settings, data types, etc.
|
|
|
|
Connect to any new database and learn on the fly the data types, database settings, etc.
|
|
|
|
Change the project RDBMS and convert the schema to a different database vendor.
|
|
|
| Design |
Edit tables, columns, indexes, foreign keys, procedures, triggers,
sequences and comments.
|
|
|
|
Drag, pan and zoom Layouts using simple mouse movements
|
|
|
|
Generate SQL statements directly from schema graphical Layout
|
|
|
|
Generate schema creation scripts
|
|
|
|
Edit schema when no database is available
|
|
|
|
View multiple layouts in the same time
|
|
|
|
Search for a table in the layout
|
|
|
| Relational Data Browse |
Simultaneously browse data from multiple tables.
|
|
|
|
Cache and paginate the database data
|
|
|
|
View the data in two modes: multiple records at a time or a single record at a time
|
|
|
|
Insert, update, and delete records.
|
|
|
|
Order and filter the browsed data.
|
|
|
|
View Large Objects (LOBs) fields as image, html, text or using an external application.
|
|
|
|
Save the browse work together with the project.
|
|
|
|
Intuitive browse using drag&drop from the layout pane.
|
|
|
| SQL editor |
Build queries by adding tables per drag&drop, following relations and clicking columns.
|
|
|
|
See the generated SQL text.
|
|
|
|
Set WHERE filters over particular columns.
|
|
|
|
Use of INNER JOIN; OUTER JOIN and EXISTS join conditions
|
|
|
|
Use Group By and aggregate functions.
|
|
|
|
Execute the generated Query.
|
|
|
|
Execute the generated Query.
|
|
|
|
Print the generated diagram.
|
|
|
|
Syntax highlights cover database keywords, functions, table names, and view names.
|
|
|
|
Auto-complete of table, view and column names
|
|
|
|
Execute SQL statements individually or as scripts
|
|
|
|
Keep multiple SQL result panes active and automatically refresh query results
|
|
|
|
Paginate and order SQL results
|
|
|
|
Explain plan
|
|
|
|
Save the SQL editing work together with the project
|
|
|
|
Save the query result directly to a file. This is useful if the result is large
|
|
|
| Database synchronization |
Synchronize local schema with the database.
|
|
|
|
List schema differences
|
|
|
|
Select which differences to keep, either on local or remote schema
|
|
|
|
Generate Merge SQL scripts based on schema differences
|
|
|
|
Upload differences on to database, with automatic step by step execution
|
|
|
|
Synchronize schemes offline ( this is synchronization with a different project file, useful for team work )
|
|
|
|
Convert the project to a different RDBMS
|
|
|
|
Generates SQL schema creation scripts for any database
|
|
|
| Documentation |
Easily document and comment tables, columns, foreign keys, indexes, etc.
|
|
|
|
Generates schema specification as an HTML/XHTML document.
|
|
|
|
Print schema Layouts with precise control
|
|
|
|
Generates schema Layout image files, in a few formats (PNG [raster] or SVG [vectorial])
|
|
|
|
Interactive documentation file images, with tool tips over the columns and tables.
|
|
|
|
Small, compact documentation files due the vectorial images. Easy to deploy in web.
|
|
|
|
Create, edit, and maintain database templates.
|
|
|