Guaranteed to save you time with your database designs

Change Log: v2.2.1

General

Reverse Synchronize has been renamed Database Compare. Perhaps the new name will be more intuitive for new users.

Attempting to Save with no design open caused an error. This is now fixed.


General GUI

Many panels, like Reverse Engineer, had their own status bars at the bottom of the panel. These status bars have been removed and the status information integrated into the panel, giving more space to the panel itself and providing a cleaner interface.

The white header panel used by many panels is now shorter, making more space available for the panel itself.


Diagrams

Diagrams now support three new entity relation (ER) notations. The new notations are Bachman, Barker and Information Engineering (IE). Use tbe Relations tab in the Edit Diagram panel to change the notation. See Figure 1.

Users can add & remove preset diagram zoom levels. Use Edit | Preferences | Diagrams to do this. See Figure 2.

Diagrams can be set to display the foriegn key name on top of the link drawn in the diagram. Use the Diagram Edit panel as shown in Figure 3.

The shading around table glyphs has been improved.


Reverse Engineering

Users can now specify schemas on the database server to ignore. Use the Ignore Schemas tab in the Edit Connection panel. These schemas will be ignored by DbWrench for Reverse Engineer, Forward Engineer and Database Compare. See Figure 4.

PostgreSQL array data types are now supported. See Figure 5. Use the DBMS Specific tab in the Edit Column panel.

MySQL reverse engineer of the index UNIQUE flag was incorrect, this is now fixed.


Forward Engineering

If a table needs to be rebuilt by the generated script, the generated script will explain using comments in the script, why the table needed to be rebuilt.

Oracle ALTER TABLE...MODIFY COLUMN... is now supported. This will make scripts generated for Oracle shorter and with fewer table rebuilds.

MS SQL Server DATE data types were erroneously scripted as DATETIME. This is now fixed.

The data type of PostgreSQL autonumber columns was not always updated if it was switched between INTEGER, BIGINT and SMALLINT. This is now fixed.


Table Data Viewer


SQL Editors

The Undo/Redo functionality in the SQL Editors didn't respond to CTRL-Z and CTRL-Y. This is now fixed.


Database Documentation

Users can now export diagrams in Scalable Vector Graphics (SVG) format. From the main menu use File | Export SVG. See Figure 6.



New diagram ER notations
Figure 1. New diagram ER notations.


Adding and removing diagram zoom presets
Figure 2. Adding and removing diagram zoom presets.


Displaying foreign key names on a diagram
Figure 3. Displaying foreign key names on a diagram.


Specifying schemas to ignore
Figure 4. Specifying schemas to ignore.


PostgreSQL array data types
Figure 5. PostgreSQL array data types.


Export diagrams in Scalable Vector Graphics (SVG) format
Figure 6. Export diagrams in Scalable Vector Graphics (SVG) format.


 




DbWrench Tip
To enforce consistant naming use the Naming Convention feature.
 
Time Saving Tip
To quickly add a foreign key to a table use the Quick Foreign Key feature.
 
 

© 2012 Nizana Systems
All rights reserved

Help
Policies
Follow Us
Tour