DbWrench 2.3.0

DbWrench is an easy to use yet very functional database design and synchronization software application.

Designing a database involves the construction of database entities such as tables, columns, foreign keys and indexes. As well as laying out tables and foreign keys on diagrams.

DbWrench provides serveral ways to interact with a database server. These include executing SQL commands, reverse engineering a database from the server and forward engineering a database design to the server.

DbWrench can generate dynamic Graphical User Interface (GUI) forms for data entry into database tables. These forms can be an alternative to writing SQL to modify data.

For example if data was to be inserted into table, DbWrench would create a form with GUI widgets for each column in the table.

Here are some key features of "DbWrench":

Diagraming Features:
· Edit database items directly in the diagram. Avoid navigating tree nodes or opening property sheets to make edits.
· Several ER notations to choose from. Including Bachman, Barker and Information Engineering.
· Multiple foreign key link algorithms. Table Direct links or FK to PK links.
· Scalable Vector Graphics (SVG) support. Export diagrams that are fully scalable.
· Use the Navigator window to easily work with large diagrams.

Multiple Vendor Compatibility:
· Supports Microsoft SQL Server, Oracle, PostgreSQL and MySQL. All with a single license.
· Runs on Windows, Linux and Mac OSX. All with a single license.

Forward Engineering:
· Generate Update DDL SQL scripts with a single click. Most database design tools only generate create scripts. DbWrench generates create and update scripts.
· Execute full scripts or select just parts of the scripts to run.
· Execute scripts in the safety of transactions.

Reverse Engineering:
· Reverse engineer existing databases in seconds.
· Insert and update table data with automatically generated forms. These forms provide data entry validation and combo boxes for foreign key fields.
· Reverse synchronize server database changes into designs.

SQL Editor:
· Syntax highlighting editor.
· Code completion.
· Create abbreviations for common commands and entity names.
· Display query results in tables or as text.

Database Design Features:
· Use column templates to add common columns quickly and easily.
· Generate HTML documentation of database designs.
· Quickly name and enforce naming conventions with Auto Naming.
· Add a foreign key with just a few clicks.

Requirements:

· Java 1.4.1 or later.

What's New in This Release: [ read full changelog ]

General:
· Automatic save on exit failed sometimes, this is now fixed.
· SQL Reserved Word warning sometimes appeared twice in a row, this is now fixed.

General GUI:
· Can save a design using Ctrl+S in addition to the current Ctrl+D.
· Can use Ctrl+Z and Ctrl+Y for undo and redo respectively. In addtion to the current Ctrl+Shift+Z and Ctrl+Shift+Y.

Diagrams:
· New diagram Click Actions to edit tables, columns, etc directly from a diagram. Reduced reliance on editing using tree navigation or grids. Just position mouse over the item to edit and click to edit.
· Diagrams now display a NULLABLE icon instead of the text NULL or NOT NULL. It is hoped that this saves space on diagrams.
· Can use DELETE key to delete glyphs from diagrams. In addition to CTRL-DELETE which was already available.
· Diagram auto layout sometimes produced a runtime error related to foreign key glyph connections. This is now fixed.
· Diagram right click popup menu only shows the menu items that are applicable for the click contex...