DbWrench是一款多平台的可视化数据库设计的同步软件。
其特点包括语法高亮的SQL查询编辑器,支持多个最流行的数据库,图形实体关系图(ERD)的设计,并正向和反向工程数据库的能力。
此软件是异构数据库环境的最理想选择。
DbWrench的主要功能包括:一款语法加强的SQL查询编辑器,支持大多数当今最为流行的数据库,一个绘图ERD(实体关系图表)设计器,“推进”(forward)和“倒退”(reverse)工程数据库的能力。
DbWrench是用纯粹的java语言编写的,这使得其可以运行于大部分操作系统平台。
对不同种类的数据库环境来说,DbWrench为一个理想的选择。
DbWrenchDbWrench 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–.zip