Menu
Your Cart

DeZign for Databases

DeZign for Databases

Need more information on this product?

Please contact us on +44 (0)20 8733 7100 or via our online form.

Contact Us

If you are not currently a customer, you can apply for an account.

Register here


  • SKU: DEZIGN


Database design and development tool using an entity relationship diagram.

DeZign for databases is a database design tool that helps you model, create and maintain databases. It uses entity relationship diagrams to graphically design databases and automatically generates most popular SQL and desktop databases.

Features

  • 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.
  • Generate reports: Generate reports, data dictionaries and databases in one click and export to HTML, MS Word or PDF.

The following databases are supported:

  • MS SQL Server
  • Oracle
  • Interbase
  • IBM DB2
  • Sybase
  • MS Access
  • Paradox
  • dBase
  • Informix
  • SQL-Anywhere
  • MySQL.

DeZign for Databases - Features

Version Comparison

FeatureStandard EditionProfessional EditionExpert Edition

Feature

Create database models (ER-diagramming)
IDEF1X Notation
Crow's Feet Notation
Subdiagrams
Autolayout diagram
Drag and drop database objects
Model validation

Model validation

Entities with attributes, indexes, constraints
Identifying and non-identifying relationships
Many-to-many relationships
Subcategories
Triggers
Views
Procedures/functions
Sequences/generators
Begin/End database and table scripts
Table options and index options

Table options and index options

Attribute packages
Domains

Domains

Print diagram
Configurable HTML, PDF, MS Word reports
Export diagram as image (JPG, GIF, BMP, WMF)

Export diagram as image (JPG, GIF, BMP, WMF)

Open file format (XML)
Internal editor with syntax highlighting
To-do list
Switch to another target database

Switch to another target database

Archive current data model
Switch to an old version
Re-generate database for an old version
Compare data model versions
Automatically create/archive versions

Automatically create/archive versions

Generate database from data model
Generate drop script

Generate drop script

Reverse engineer from many popular DBMS systems
Smart Relationship Finder to infer non declared relationships

Smart Relationship Finder to infer non declared relationships

Update database based on changes made in the data model (generate intelligent alteration code)

Update database based on changes made in the data model (generate intelligent alteration code)

Multiple databases are supported.

DeZign for Databases - System Requirements

  • Microsoft Windows 95 or later, NT, 2000 or XP
  • 16 MB RAM minimum
  • 486 processor
  • 6 MB available hard disk space.