17.9 Reverse Engineering (Revision #31)

You can generate an ER Modeler from DDL Scripts, allowing conversion of database commands into diagrams. There are two methods of Reverse Engineering within Aqua Data Studio, importing a database and generating an ER diagram through the Schema Browser. Importing a database is accomplished through the ER Modeler Menu Bar under Tools->Import Database. Within the Main Application Menu of Aqua Data Studio, Tools->Generate ER Diagram can be used for Reverse Engineering. An object in the  Schema Browser can also be right clicked for Tools->Generate ER Diagram.

Import Database

Before a database can be imported an existing ER Diagram must exist with the database vendor and version chosen.

1. Select Tools->Import Database from the Menu Bar.

2. Select the database server from the connections list

3. Choose the object types and objects to import, click next.

4. View the progress of the import.

5. The objects selected for import display in the current ER Model as entities.

Generate ER Diagram (Schema Browser)

From within Aqua Data Studio's Schema Browser

1. Right click on the desired database or schema object and select Tools->Generate ER Diagram (or choose Tools->Generate ER Diagram from the Main Application Menu and select the database server and database).

2. Choose the object types and objects to be generated in the ER diagram and click next

3. View the progress of the ER Diagram generation.

4. The objects selected for ER Diagram generation display in the ER Modeler as entities in a new, unnamed diagram.

To convert database scripts into a Diagram

1. Select "ER Diagram Generator" from the Tools Menu

2. Select the desired schema objects you want in the diagram

3. Click on Next to initialize the ER Diagram Generator.

4. View its status for errors and elapsed time

The resulting Model contains all of the database Objects within the database.