DeZign for Databases

DeZign for Databases - A database design tool for developers and DBA's that can help you model, create and maintain databases
DeZign for Databases is an intuitive database design tool for developers and DBA's that can help you model, create and maintain databases.

DeZign for Databases uses entity relationship diagrams (ERDs) to graphically design databases and automatically generates the most popular SQL and desktop databases.

Supported Databases:
MySQL, Oracle, InterBase, IBM DB2, PostgreSQL, MS SQL Server, Firebird, MS Access, Paradox, dBase, Pervasive, Informix, Clipper, Foxpro, Sybase, NexusDB, DBISAM

Main features of DeZign for Databases:

Visual Database Modeling

DeZign for Databases will offer a intuitive visual interface that will allow you to accurately design your database. It uses entity relationship diagrams (ERDs) to graphically design databases and produces high quality database diagrams, enabling you to present your design at various levels of detail.

Report Publishing Functions

Several data model reports with different levels of detail can be generated. Descriptions and other relevant information will be exported to HTML, MS Word or PDF.

Database Lifecycle Support

Generate databases: Generate complete DDL scripts to create your database or generate your database directly.

Import databases: Derive a graphical data model from existing databases.

Modify databases: Changes made to the data model can be applied to a database. DeZign for Databases will generate intelligent alteration code to modify your database.


Requirements of DeZign for Databases:

Minimum of 16MB RAM and will run on a 486 processor.

Disk space requirements is 6 MB


Limitations of DeZign for Databases:

30 days trial


What's New in This Release:

Grid-based Editing: New grid-based editors for attributes, indexes, table constraints, domains, sequences, procedures and views. The grid view provides a convenient means for viewing and editing database object properties. With its spreadsheet-like interface, the grid view allows users to easily manipulate database object properties. You can move in the grid by using the TAB-key, Enter-key and keyboard arrows. At the bottom of such a grid a property editor is shown which will display the property values for the selected object.

IDEF1X Modeling Notation Support: In addition to Crow's Feet, the industry standard design notation IDEF1X is now supported. Each subdiagram can use its own notation: Relational/Crow's Feet or IDEF1X.

Alter Database Functionality: Generate Alter database SQL scripts based on a comparison between two versions (supported for Oracle, InterBase, MySQL, Firebird and MS SQL Server). Alter a MS Access database directly based on a comparison between two versions.
Compare Versions and Extensive Version Management:

Automatic version creation. When generating or altering a database, a version is archived.

New Manage versions dialog with functionality to add, edit, delete and compare data model versions.

Compare two versions and examine the differences in a differences browser.

Export an overview of the differences between two versions to a HTML file.

Regenerate the database for an archived version.

Integrated Reverse Engineering Support: DeZign for Databases V4 now allows you to reverse engineer complete databases with a direct native connection. A direct connection to import databases directly is available for Oracle, MySQL, InterBase, Firebird, MS SQL Server, MS Access, Paradox, dBase, FoxPro, DBISAM, Clipper and NexusDB. You can also reverse engineer existing databases through SQL scripts with the improved SQL script analyzer. You don't need the separate ImportER products for reverse engineering tasks anymore.

Reusable Attributes (Packages): Attribute packages are reusable user-defined attributes that promote consistent attribute definitions. You construct attribute packages as you would entities, specifying a name, attributes with datatype properties, default values and validation rules. Afterwards, you can reuse these attribute packages in your data model by applying them to entities.
Enhanced Diagramming Tools:

Pan around a diagram with the Hand tool (like in Adobe Reader).

Smooth direct scrolling when using the scrollbar.

Better mouse-wheel support. The diagram doesn't scroll anymore when the diagram does not have the focus. The steps taken are smaller which results in much smoother scrolling.

Move selected objects using the keyboard arrows.

Group entities or other diagram objects by using the groupbox object.

Add entities to a subdiagram by dragging them from the Object Browser and drop them on the diagram.

Configurable HTML, PDF and MS Word Reports: DeZign for Databases V4 now allows users to configure which elements to include or to exclude when generating data model reports. Instead of generating standard reports, users now have a great deal of control over the content and structure of their reports.

Target Database Related Enhancements

Newly supported: Oracle 10g, MySQL 5, NexusDB 2, Firebird 2, MS SQL Server 2005, PostgreSQL 8 and MS Access 2003.

Enhancements available for: Oracle 7,8,9, MS Access 95,97,2000, PostgreSQL 7, Informix 9, DBISAM 3,4, NexusDB 1, MySQL 3,4, InterBase 5,6,7, Firebird 1.5, Paradox, Clipper, FoxPro, MaxDB, MS SQL Server 6.5,7,2000, DB2 Universal DB 7,8, Sybase 11,12, Pervasive 8,9 and dBase.

Oracle 10g Support

Reverse engineer Oracle 10g databases with a direct connection or through SQL scripts.

Generate Oracle 10g databases.

Alter Oracle 10g databases. Generate intelligent alteration code for Oracle 10g databases by comparing two versions of your data model.

Compare Oracle 10g data models.

Enhanced Oracle 7,8,9 Support
In addition to forward engineering (generating) Oracle 7,8 and 9 databases, DeZign for Databases now also offers:

Reverse engineer Oracle 7,8,9 databases with a direct connection or through SQL scripts.

Alter Oracle 7,8,9 databases. Generate intelligent alteration code for Oracle 7,8,9 databases by comparing two versions of your data model.

Compare Oracle 7,8,9 data models.

Support for Not null constraint names.

MySQL 5 Support

Reverse engineer MySQL 5 databases with a direct connection or through SQL scripts.

Generate MySQL 5 databases including triggers, procedures and views.

Alter MySQL 5 databases. Generate intelligent alteration code for MySQL 5 databases by comparing two versions of your data model.

Compare MySQL 5 data models.

Enhanced MySQL 3,4 Support
In addition to forward engineering (generating) MySQL 3,4 databases, DeZign for Databases now also offers:

Reverse engineer MySQL 3,4 databases with a direct connection or through SQL scripts.

Alter MySQL 3,4 databases. Generate intelligent alteration code for MySQL 3,4 databases by comparing two versions of your data model.

Compare MySQL 3,4 data models.

PostgreSQL 8 Support

Reverse engineer PostgreSQL 8 databases through SQL scripts.

Generate PostgreSQL 8 databases.

Compare PostgreSQL 8 data models.

Enhanced PostgreSQL 7 Support
In addition to forward engineering (generating) PostgreSQL 7 databases, DeZign for Databases now also offers:

Reverse engineer PostgreSQL 7 databases through SQL scripts.

Compare PostgreSQL 7 data models.

Support for Not null constraint names.

Firebird 2 Support

Reverse engineer Firebird 2 databases with a direct connection or through SQL scripts.

Generate Firebird 2 databases.

Alter Firebird 2 databases. Generate intelligent alteration code for Firebird 2 databases by comparing two versions of your data model.

Compare Firebird 2 data models.

Enhanced Firebird 1.5 Support
In addition to forward engineering (generating) Firebird 1.5 databases, DeZign for Databases now also offers:

Reverse engineer Firebird 1.5 databases with a direct connection or through SQL scripts.

Alter Firebird 1.5 databases. Generate intelligent alteration code for Firebird 1.5 databases by comparing two versions of your data model.

Compare Firebird 1.5 data models.

Character sets, blob subtypes and segment sizes supported.

Collations support.

RECREATE TABLE recognized by the SQL parser.

Enhanced InterBase 5,6,7 Support
In addition to forward engineering (generating) InterBase 5,6,7 databases, DeZign for Databases now also offers:

Reverse engineer InterBase 5,6,7 databases with a direct connection or through SQL scripts.

Alter InterBase 5,6,7 databases. Generate intelligent alteration code for InterBase 5,6,7 databases by comparing two versions of your data model.

Compare InterBase 5,6,7 data models.

Character sets, blob subtypes and segment sizes supported.

Collations support.

MS SQL Server 2005 Support

Reverse engineer MS SQL Server 2005 databases with a direct connection or through SQL scripts.

Generate MS SQL Server 2005 databases.

Alter MS SQL Server 2005 databases. Generate intelligent alteration code for MS SQL Server 2005 databases by comparing two versions of your data model.

Compare MS SQL Server 2005 data models.

Enhanced MS SQL Server 6.5,7,2000 Support
In addition to forward engineering (generating) MS SQL Server 6.5,7,2000 databases, DeZign for Databases now also offers:

Reverse engineer MS SQL Server 6.5,7,2000 databases with a direct connection or through SQL scripts.

Alter MS SQL Server 6.5,7,2000 databases. Generate intelligent alteration code for MS SQL Server 6.5,7,2000 databases by comparing two versions of your data model.

Compare MS SQL Server 6.5,7,2000 data models.

Support for Not null constraint names.

Support for Default constraint names.

MS Access 2003 Support

Reverse engineer MS Access 2003 databases with an ADO connection.

Generate MS Access 2003 databases.

Alter MS Access 2003 databases.

Compare MS Access 2003 data models.

Enhanced MS Access 95,97,2000 Support
In addition to forward engineering (generating) MS Access 95,97,2000 databases, DeZign for Databases now also offers:

Reverse engineer MS Access 95,97,2000 databases with an ADO connection.

Alter MS Access 95,97,2000 databases by comparing two versions of your data model.

Compare MS Access 95,97,2000 data models.

Enhanced DB2 Universal DB 7,8 Support
In addition to forward engineering (generating) DB2 Universal DB 7,8 databases, DeZign for Databases now also offers:

Reverse engineer DB2 Universal DB 7,8 databases through SQL scripts.

Compare DB2 Universal DB 7,8 data models.

Support for Not null constraint names.

Support for Default constraint names.

Enhanced Sybase 11,12 Support
In addition to forward engineering (generating) Sybase 11,12 databases, DeZign for Databases now also offers:

Reverse engineer Sybase 11,12 databases through SQL scripts.

Compare Sybase 11,12 data models.

Support for Not null constraint names.

Support for Default constraint names.

Enhanced Pervasive 8,9 Support
In addition to forward engineering (generating) Pervasive 8,9 databases, DeZign for Databases now also offers:

Reverse engineer Pervasive 8,9 databases through SQL scripts.

Compare Pervasive 8,9 data models.

Enhanced Informix 9 Support
In addition to forward engineering (generating) Informix 9 databases, DeZign for Databases now also offers:

Reverse engineer Informix 9 databases through SQL scripts.

Compare Informix 9 data models.

Enhanced MaxDB Support
In addition to forward engineering (generating) MaxDB databases, DeZign for Databases now also offers:

Reverse engineer MaxDB databases through SQL scripts.

Compare MaxDB data models.

Enhanced DBISAM 3,4 Support
In addition to forward engineering (generating) DBISAM 3,4 databases, DeZign for Databases now also offers:

Reverse engineer DBISAM 3,4 databases with a direct connection.

Enhanced dBase Support
In addition to forward engineering (generating) dBase databases, DeZign for Databases now also offers:

Reverse engineer dBase databases with a direct connection.

A new and more reliable database connectivity component is used to connect to dBase tables. The BDE is not used anymore to connect to dBase tables.

Enhanced Clipper Support
In addition to forward engineering (generating) Clipper databases, DeZign for Databases now also offers:

Reverse engineer Clipper databases with a direct connection.

A new and more reliable database connectivity component is used to connect to Clipper tables.

Enhanced FoxPro Support
In addition to forward engineering (generating) FoxPro databases, DeZign for Databases now also offers:

Reverse engineer FoxPro databases with a direct connection.

A new and more reliable database connectivity component is used to connect to FoxPro tables.

Enhanced Paradox Support
In addition to forward engineering (generating) Paradox databases, DeZign for Databases now also offers:

Reverse engineer Paradox databases with a direct connection.

NexusDB 2 Support

Reverse engineer NexusDB 2 databases with a direct connection.

Generate NexusDB 2 databases including triggers, procedures and views.

Enhanced NexusDB 1 Support
In addition to forward engineering (generating) NexusDB 1 databases, DeZign for Databases now also offers:

Reverse engineer NexusDB 1 databases with a direct connection.

Free Download ( Evaluation | 5.3 MB )