DbWrench

DbWrench 5.1.1

Database design and SQL engineering tool

DbWrench combines a graphical ERD designer, SQL editor, and database engineering tools for developers and database administrators. It can create schemas, reverse engineer existing databases, generate update and synchronization scripts, and translate designs between supported database systems. The syntax-highlighting editor runs queries and presents results in tables or text.

DbWrench 5.1.1 details

Author:
License: Shareware
Price: $149.00
Released:
File size: 40.30 MB
Downloads: 449
Keywords: sql query editor, database reverse engineering, Nizana Systems, designer, database design software, schema migration tool, query editor, database, generate HTML, query, database design, data synchronization, SQL editor, cross-platform compatibility, DbWrench, database documentation generator, erd diagram editor
Author URL: http://www.dbwrench.com/
DbWrench screenshot
DbWrenchOther Server ApplicationsWindows XP, Windows Vista, Windows Vista x64, Windows 7, Windows 7 x64, Windows 8, Windows 8 x64, Windows 10, Windows 10 x64, Windows 11

User Rating: 2.3 (13 votes)

Windows 10

x32

Windows 10

x64

DbWrench Awards

Windows 10 download editor's pick

DbWrench for Windows 10 - Full description

DbWrench is a database design and round-trip engineering tool for developers and database administrators who need to model schemas, work with SQL, and keep a design aligned with an existing database. Its graphical entity relationship diagram (ERD) designer provides a visual way to create and inspect tables and their relationships, while database-specific SQL support helps adapt design and query work to different systems.

The software can forward engineer a design by generating SQL to create or update a database, and reverse engineer an existing database to build a design from its schema. When a server schema changes, DbWrench can generate synchronization scripts based on the current database structure and record forward-engineering results and errors in a log. It also supports translating a schema from one supported database system to another, which can help when migrating or comparing database designs.

For day-to-day SQL work, the built-in query editor uses syntax highlighting and tailors SQL to the selected database management system. Users can select and run part of a script, execute multiple queries at the same time, and view results in tables or as text. Tabular results can be sorted by clicking column headers. The editor also supports abbreviations for frequently used commands and entity names, and can translate some proprietary database commands between systems.

Additional design tools help speed up common tasks: table templates add frequently used columns, and foreign keys can be added with a single click. Table and foreign-key color coding makes diagrams easier to read. Designs can be documented as HTML, while ERDs can be exported as PNG or JPEG images for sharing or inclusion in project materials. These options support workflows ranging from initial schema planning to maintaining documentation for a live database.

DbWrench supports MySQL, PostgreSQL, Microsoft SQL Server, and Access, with support for most PSQL commands. It is written in Java and is designed to run across multiple operating systems; the Windows release supports Windows 10 and Windows 11. The program is shareware, so use is subject to its licensing terms.

DbWrench for Windows 10 - Post your review