DeZign for Databases V6.0 Adds Support for Bidirectional Synchronization of Models and Databases

Posted on 2009-11-26

With version 6, DeZign for Databases offers compare and synchronize functionality for all database/model synchronization use cases: model-to-database, model-to-script, database-to-model, script-to-model, model-to-model. This version also enables teams to work together more easily with the compare and merge models utility and introduces database-independent modeling. Diagrams will look even smoother with new more flexible relationship line routing algorithms and gradiency settings for diagram objects.

Billed as the starting point for successful database development, DeZign for Databases is used by database developers and other software professionals to visually design data models and automatically generate databases, or to reverse engineer existing databases into diagrams, then fine tune the designs, and complete the round trip by regenerating/synchronizing with your database. You can also use the tool to document your database. Customizable data model reports with different levels of detail can be generated.

New features in DeZign for Databases V6 include:

  • Compare your model to your (live) database and update your database.

  • Conditional generation. {$IFDEF myvar}Do Something {$ENDIF}.

  • More flexible relationship lines with new line routing algorithms.

  • Undo-support.

  • Team work with the compare and merge models/projects utility.

  • Database-independent modeling. Forward engineer one model to multiple database types.

  • Added compare options such as ignore primary key constraint name differences etc. when comparing a database to a data model.

  • Redesigned report generator. Now completely customizable with the possibility to load and save report templates.

  • Compare data model versions and update model after comparing it to the database now supported for all databases.

  • Improved alter script (synchronize script) generation.

  • Improved support for working with indexes on keys.

  • Option to automatically create a subdiagram for each schema in a database when reverse engineering the database.

DeZign for Databases supports PostgreSQL, Oracle, MySQL, MS SQL Server, MS Access, DB2, InterBase, Firebird, Sybase, DBISAM, Paradox, FoxPro, dBase, Clipper, Pervasive SQL, Informix.

This post has been migrated from a previous version of the PostgreSQL website. We apologise for any formatting issues caused by the migration.