DbWrench Features

What is DbWrench Features?

Diagramming features

• Edit the database items directly on the diagram.
• Avoid navigating tree nodes and editing property sheets.
• Multiple ER notations to choose from.
• Including Bachman, Barker and Information Engineering.
• Use the Browser window to easily work with large diagrams.

Database design features

• Use column templates to quickly and easily add common columns.
• Generate HTML documentation for database projects.
• Quickly name and enforce naming conventions with Automatic Naming.
• Add a foreign key with just a few clicks.

Advanced Engineering

• Generate update DDL SQL scripts with a single click.
• Most database design tools generate only authoring scripts. DbWrench generates authoring and updating scripts.
• Run full scripts or select partial scripts to run.
• Run scripts on transaction security.

Reverse engineering

Reverse engineer existing databases in seconds.

Enter and update table data with automatically generated forms. These forms provide data entry validation and combo boxes for foreign key fields.

Reverse synchronization of the server database changes back to the designs.

Editor SQL

Syntax highlighting editor.

Code completion.

Create abbreviations for common commands and entity names.

View query results in tables or as text.

Multi-vendor compatibility

Supports Microsoft SQL Server, Oracle, PostgreSQL and MySQL. All with a single license.

System requirement

Runs on Windows, Linux, and Mac OSX.