Reverse engineering an existing database

 

ERBuilder data modeler allows you to reverse engineer an existing database to create a new model. You have the ability to reverse engineer a local or a remote database.

To reverse engineer an existing database:

1.         Select “File | Reverse Engineer” from the main menu:

image

2.         In the “Reverse Engineering” dialog box, select a local or remote connection and click on “Next”.  You can also create a new connection by clicking the “new connection” button (see the section Connections Management.)

 

image

 

3.        In the next step, select the items to be imported (Tables, Views, Procedures and Sequences), then click on “Import”:

image

 

In the console below, the process will display a notification regarding the success or failure of the database items import.

 

image

 

-          Tables and relationships are positioned on the diagram.

 

Available in: Professional and Enterprise Editions