Guaranteed to save you time with your database designs

Change Log: v2.2.0

General

The number of Java & NetBeans modules used by the application has been reduced by about 30%. This has reduced the zip distributable file size significantly and has slightly improved application startup time.

Print preview now shows the page margins in the preview.

In the main application status bar the INS text ran up against the current design name text. A spacing gap has now been added.

A toolbar button as been added to the main toolbar for the Open Design action.

Many menu items in the main menu have had icons added to them. Particularly in the Window menu. This should make finding particular items easier.


General GUI

In the Connection Edit panel, if MS Access is selected the irrelevant text fields are now hidden.

In the Connection Edit panel, if Oracle is selected the Database Name label now displays SID or Service. Which is more in keeping with how Oracle connections are defined.

The Connection Edit panel's layout has been tweeked to make it more space efficient.

In Database Explorer, the diagram node popup menu now has a Remove menu item.

In Database Explorer, the diagram node popup menu now has a Diagram Properties menu item.


Diagrams

Diagram refresh and redraw performance has been improved. Particularly at the zoom level of 100%. Other zoom levels still need to be optimized.

The diagram will auto scroll when mouse is dragged beyond the diagram panel's limits.

Diagram link lines are now always drawn under table glyphs.

Diagram link lines are now always drawn over glyph shadows making link cardinality easier to read.

When a table glyph is dragged, it's links are continuously redrawn during the drag operation.

When the mouse cursor passes over a link in a diagram, the link and the columns involved in that link are highlighted.

The sliding speed of the auto locating glyphs functionality has been increased.

Changing the background color of a table, zone or note glyph is now stored. This stored color is then applied automatically to the next table, zone or note glyph added.

Clicking on a table glyph in the navigator panel now automatically slides the diagram to show that table glyph.

Navigator panel's background color now matches the diagrams background color.

Pressing the shift key while the mouse is over a diagram now shows a closed hand cursor rather than an open hand cursor. Making the cursor behaviour more standardized.

Menu items in the diagram popup menu were missing accelerator (short cut) keys. These have now been added.


Reverse Engineering

Oracle triggers were sometimes associated with the wrong table. This is now fixed.

Reverse engineer of Oracle NUMBER types with NULL precision sometimes created a null exception. This is now fixed.

Oracle TIMESTAMP types were erroneously reverse engineered as custom types. This is now fixed.

Reverse engineer of case sensitive MS SQL Server databases resulted in several errors. These are now all fixed.

Oracle connections that specified SID failed because the JDBC URL was malformed. This is now fixed.

A generic connection, available in DbWrench to generate create script DDL, was not available for Oracle. Now it is.

Reverse Synchronize now automatically highlights and sets focus to the first row of the grid after a refresh.


Forward Engineering

Oracle DDL generated for NUMBER types with both the length and the scale specified was incorrectly formatted. This is now fixed.

MS SQL Server forward engineer DDL now always specifies the schema name even if there is only one schema. This keeps items from automatically being added to the dbo schema.

If a PostgreSQL 8.4 schema a was renamed, DROP INDEX generated DDL statements would still used the old schema name. This is now fixed.


Table Data Viewer

Editing Oracle row data did not show combo boxes for foreign key fields. This is now fixed.

On some smaller instantiations of the Row Edit panel, a vertical scrollbar was displayed even though it was not necessary. This is now fixed.


SQL Editors

The SQL Results grid now allows single cell selection rather than just row selection. This should allow users to copy (via CTRL+C) just the single cell value they want.


Database Documentation



 




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.