You can reverse engineer a number of databases, such as Sybase ASA and ASE, Oracle, PostgreSQL, Informix, MSSQL and others. This means that you can extract tables, attributes, relationships, indexes and other objects. It is possible with the Universal Reverse Engineering tool, which connects to a number of databases through OLEDB (ADO) or ODBC link. So, to reverse engineer a particular database, you need a corresponding OLEDB provider, or ODBC driver. In most cases, such libraries are installed in the system with the help of database client applications.
To reverse engineer a database through OLEDB or ODBC link:
1. Select Universal Reverse Engineering item from Reverse Engineering drop-down menu on Database tab of the Ribbon.
2. If the currently opened diagram already contains some objects, the following dialog box will appear:
3. The Universal Reverse Engineering tool will be shown. First, provide full OLEDB connection string in the Connection tab.
4. You can set reverse engineering options in the Options tab:
Tables and Views
Tables in a diagram row
Garbage symbols remove/replace
Automatically rebuild references when no reference is reversed
Convert Unique Indexes to Primary Keys
5. In the Selection tab of the Universal Reverse Engineering tool you can choose the tables you want to reverse engineer.
6. Click OK to start the database reverse engineering process. The Output -> Reverse docking window will display the state of the process.
7. The reversed database objects will be placed in your diagram.