dbWrench
|
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, capability 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.
Key Features
1. Simple to Learn, Easy to Use
2. Create Entity Relation Diagrams (ERDs)
3. Forward Engineer New Databases
4. Reverse Engineer Existing Databases
5. Synchronize your databases and designs in either direction
6. Advanced SQL Query Editor
7. Cross Platform Support
Design Features
1. Use column templates to add common columns quickly and easily
2. Generate HTML documentation of database designs
3. Quickly name and enforce naming conventions with Auto Naming
4. Add a foriegn key with just a few clicks
Forward Engineering
1. Update DDL scripts generated based on differences between design and server databases
2. Execute only select parts of scripts
3. Support for transactions
Reverse Engineering
1. Reverse engineer existing databases
2. Insert and update table data with automatically generated forms, which provide entry time data validation and combo box entry for foreign key fields
3. Reverse synchronize server database changes into designs
Diagraming Features
1. Navigator window to easily navigate diagrams
2. Multiple foreign key link algorithms
3. Selecting a foreign key highlights the columns used in that foreign key
SQL Editor
1. Syntax highlighting editor
2. Code completion
3. Create abbreviations for common commands and entity names
4. Display query results in tables or as text
Multiple Vendor Compatibilty
1. Currently supports Microsoft SQL Server, PostgreSQL and MySQL
2. Multiple operating system support including Windows, Linux and Mac
The license of this software is Free Trial Software, the price is $149, you can free download and get a free trial before you buy. If you want to get a full or nolimited version of dbWrench, you can buy this database management software software.

