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 written in pure java allowing it run on numerous operating systems.
Here are some key features of "DbWrench":
· Generate HTML documentation of database designs
· Export ERDs to PNG and JPEG formats
· Color coding of database tables and foreign keys
· Table templates make adding common columns easy
· Add foriegn keys with a single click
· 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 engineer existing databases
· Translate database schema from one DBMS to another
· Full round-trip engineering including generating update scripts
· Currently supports MySQL, PostgreSQL, Microsoft SQL Server and Access
· Multiple operating system support
· 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
· Minimum Pentium II 400 MHz
Limitations:
· 7 days trial period
What's New in This Release: [ read full changelog ]
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.
· Users can add & remove preset diagram zoom levels. Use Edit | Preferences | Diagrams to do this.
· Diagrams can be set to display the foriegn key name on top of the link drawn in the diagram.
· T...