Guaranteed to save you time with your database designs

Change Log: v2.1.0

General

Direct support for printing large diagrams over multiple pages. See Figure 1.

Default memory allocation for the application is increased to 256 MB.

Repeated use of the color chooser on some Linux machines resulted in an error, this is now fixed.

Can specify primary key in the same panel when creating the column itself.

Print preview for printing diagrams directly to a printer
Figure 1. Print preview for printing diagrams directly to a printer.

General GUI

New upgraded look and feel for the application.

'Save Database' menu items and such have been renamed to 'Save Design', etc.


Diagrams

The number of tables that can be used with autolayout are now unlimited.


Reverse Engineering

Support for reverse engineering Oracle databases.

Support for PostgreSQL 9, MySQL 5.5 and SQL Server 2008r2

Upgraded to use the latest JDBC drivers for each of the supported database management systems. Resulting in improved performance and reliability.

If a PostgreSQL trigger referenced a function in another schema this caused an error. This is now fixed.

Reverse engineer of PostgreSQL functions did not distinguish between 'returns setof record' and 'returns table', this is now fixed.

Reverse engineer of PostgreSQL functions did not recognize COST and ROWS values, now it does.

Reverse engineer of PostgreSQL functions left out the space between IMMUTABLE and the following qualifier, this is now fixed.

Reverse engineer of PostgreSQL functions did not recognize the path location specified for external function calls, now it does.

Reverse engineer of MS SQL Server triggers failed if there were extra line feeds after the 'AS' clause, this is now fixed.

Reverse engineer of MS SQL Server multicolumn foreign keys sometimes reversed the order of the columns in foreign key, this is now fixed


Forward Engineering

Support for forward engineering Oracle databases.

Edit Connection panel now warns users if they have any trailing spaces in any of the fields used to define a server connection.

Added HTML links to the edit server connections panel to help users who may be having problems getting their connection to work.

PostgreSQL generated scripts did not enclose entity names containing a dash in quotes, this is now fixed.

Create DDL for sequences sometimes added an unnecessary space at the start of the DDL, this is now fixed.

Forward engineer of NUMERIC datatypes were scripted as MONEY, this is now fixed.

MySQL BIT datatypes were scripted as TINYINT, this is now fixed.


Table Data Viewer


SQL Editors

Code complete now has entries for names of user objects in the current design. See Figure 2.

Code complete's popup speed has been improved.

Using optional parameters to specify a SQL Server named instance
Figure 2. Code complete for user object names.

Database Documentation


 




DbWrench Tip
To enforce consistant naming use the Naming Convention feature.
 
Only One Edition
There are no Professional or Enterprise editions of DbWrench.
Just one edition.
It includes all the features and supports all database systems mentioned on this site.
 
Time Saving Tip
To quickly add a foreign key to a table use the Quick Foreign Key feature.