Entity Relationship Modeler

The Aqua Data Studio Entity Relationship Modeler (ER Modeler) helps you design complex database models for all major RDBMS vendors and versions. Use the Forward Engineer feature to model entities and convert them into SQL Scripts, or Reverse Engineer existing databases to visualize a database model. You can quickly convert models from one database vendor to another using the Convert feature. The Schema Compare Tool functionality within the ER Modeler allows comparing ER Models. The Import feature allows adding entities from existing databases into an ER model. ER models can also be stored in version control to keep track of changes.



The ER Modeler can be used for:

Model Complex Databases and Data Warehousing Designs

The ER Modeler allows you to create professional database designs with its rich set of features. A graphic display1 of database objects can be created manually by adding entities on a sheet and altering their attributes. Model a complex database by dragging and dropping tables, indexes, constraints, relationships, notes and regions from the Palette. Easy and visual database management.Model Complex Databases and Data Warehousing Designs screenshots ER Modeler

Group Entities into Region

Regions are used to group displayed objects in a sheet. To make a region, drag one around the objects you wish to group. You may then move Regions around, to move a group of objects.Group Entities into Region screenshots Region

Enable different Display Levels

Use the Display options to model diagrams based on Attribute, Primary Key, Entity, Physical Schema, Nullable Columns, Comments or Relationship Names. An option for Schema Folder Grouping is also available. Enable different Display Levels screenshots Schema Folder Grouping

Reverse Engineer to visualize Database Structure

An ER diagram can be extracted from an existing database (commonly referred to as reverse engineering2) and its schema objects displayed as a model by using Tools->ER Diagram Generator in the Server Browser. Reverse Engineer to visualize Database Structure screenshots ER Modeler - Reverse Engineering a Database into a Model

Import Database to ER Model

A powerful and flexible feature of the ER Modeler is the Import support under Tools-> Import Database, which allows you to add tables and views from existing databases into your model.Import Database to ER Model screenshots Import Database Objects

Compare ER Models and Databases

The ER modeler is integrated with the Aqua Data Studio Schema Compare Tool. It allows comparing two ER models, or an ER model to an existing database. The differences are shown in a graphical notation and accompanied with DDL scripts that can create, delete or alter corresponding objects.Compare ER Models and Databases screenshots Comparing Two ER Models | Comparing a Database to a Model

Quick Search Entities

Use Ctrl-G to quickly locate and identify database entities in the ER Model.Quick Search Entities screenshots Quick Find

Version Control Integration

Aqua Data Studio provides integration with several version control systems like CVS, Subversion (SVN), Git and Perforce. Developers in an organization can access ER Models associated with a version control repository, modify and track their changes.Version Control Integration screenshots ER Modeler - Mounted Scripts Folder with Model's SVN History

Add Entities and Relationships

The ER Modeler supports Information Engineering (IE) notation. To add a table, click on the Table Entity in the Palette and then drag within the sheet to create it. Double click to alter its properties. Comments appear at the bottom of table entities. Properties for a selected entity are displayed in the Object Properties pane at the bottom of the window. Sheets are views of the model and multiple sheets can be added to a diagram.Add Entities and Relationships screenshots Drag to Create Objects

Views and Sheet Layout

The ER Modeler has a rich set of features for choosing model views and built-in sheet layouts, which make your data visualization much easier. 1:1 Scale, Zoom In, Zoom Out, Fit to Window are the different views available. You can adjust the "zoom" of the model with the mouse scroll wheel.Views and Sheet Layout screenshots Sheet - Show in Diagram

Forward Engineer Model into Database

An ER diagram can be quickly converted into a DDL3 script using Tools->Generate Script. The script can be executed in a Query Analyzer window to populate a database with objects.Forward Engineer Model into Database screenshots ER Modeler - Forward Engineering a Model into a Database

Universal Schema Migrations

The DDL of one database can be converted to the DDL of another database through the use of the "Convert to…" tool to ease migration4 from one database vendor to another.Universal Schema Migrations screenshots ER Modeler - Convert Model

Save as Image

ER Models can be saved as a JPG or PNG image for inclusion in word processing documents or presentation slides.Save as Image screenshots Save as Image

Print ER Models and Generate HTML Reports

ER Models can be printed for quick reference. It is easy to set the dimensions of the printout to fit your needs. They may be printed across multiple pages. You can generate HTML reports from models, which include HTML navigation elements and detailed information about database objects.Print ER Models and Generate HTML Reports screenshots Print Preview | Generating HTML Reports

Video Tutorial

Aqua Data Studio Entity Relationship (ER) Modeler - database management made simple - flash video Create Entity Relationship (ER) Diagram Models, script DDL from a model, compare models, convert models from one database to another and much more.
Duration: 10 minutes

References

  1. ^ ER Diagram Wikipedia article.
  2. ^ Reverse Engineering Wikipedia article.
  3. ^ DDL Wikipedia article. Data Definition Language.
  4. ^ Database Migration Wikipedia article. See "Database Migration" paragraph.

Home Aqua Data Studio Aqua Data Server AquaClusters Support Buy Company Privacy

Copyright © 2001–2014 AquaFold, Inc. All Rights Reserved.