DbWrench is a multi vendor, cross platform database design and round-trip engineering software.
DbWrench`s features include: a graphic entity relation diagram (ERD) designer, ability to forward and reverse engineer databases, a syntax highlighting SQL query editor, and support for many of today`s most popular databases.
DbWrench is a tool written in pure java allowing it run on numerous operating systems.
Its multi vendor and multi platform functionality makes it ideal for heterogeneous database environments.
This download is marked as adware because it displays advertisement banners or other type of commercials while running.
Here are some key features of "DbWrench":
· ERD Features.
· Generate HTML documentation of database designs.
· Color coding of database tables and foreign keys.
· Table templates make adding common columns easy.
· Add foriegn keys with a single click.
· Forward Engineering.
· SQL is customized for each specific DBMS.
· Synchronization scripts generated based on current server database schema.
· Generates a log of forward engineering results and errors.
· Select portions of SQL scripts to execute.
· Reverse Engineering.
· Reverse engineer existing databases.
· Translate database schema from one DBMS to another.
· Full round-trip engineering including generating update scripts.
· Reverse synchronize database changes into designs.
· Multiple Vendor Compatibilty.
· Currently supports MySQL, PostgreSQL, and Microsoft SQL Server.
· Multiple operating system support.
· Query Editor.
· Syntax highlighting editor.
· Create abbreviations for common commands and entity names.
· Execute multiple queries simultaneously.
· Display query results in tables or as text.
· Sort result sets by clicking on table headers.
· Translate common proprietary DBMS commands to another DBMS.
· Support for most PSQL commands.
Requirements:
· Java 1.4.1 or later.
What`s New in This Release: [ read full changelog ]
General:
· The Connection Edit panel now has an Optional Parameters field which can be used to specify the name of a MS SQL Server named instance. Use the `instance=myinstance` format.
· MySQL users can use the same Optional Parameters field to specify that a connection use Unicode.
· Config files for older DbWrench versions produced errors when being loaded. This was because they referred to (Unknown) data types as (Custom) still. This is now fixed.
· Edit Connection panel only shows DSN information if a MS Access database is selected. Otherwise it hides this field.
· Edit of Note texts are now undo-able. The bug that prevented them from being undone has now been fixed.
· Undo of Add Note tool tip displayed a numeric ID which wasn`t very helpful. Now it displays `Add Note`.
· Redo after an Undo of an Add Table command sometimes failed. This has now been fixed.
· The New Table edit panel no longer contains the Column Sorting tab. This slightly simplifies the interface.
Diagrams:
· Holding down the C...
