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.
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.

This download is marked as
adware because it displays advertisement banners or other type of commercials while running.