Database reverse engineering tools
In this set of notes we introduce the concept of database reverse engineering and walk through three different software tools that can be used to carry out database reverse engineering.
For example, a Many to Many (M:N) relationship is represented as an intersection relation.
Also, the names of the relationships are lost.
Reverse Engineering using Sybase PowerDesigner
Sybase PowerDesigner has the ability to reverse engineer a database schema into a physical model. What follows is an example data warehouse schema that exists in an Oracle database. Note that this example is from an older version of PowerDesigner, however the steps should still apply to newer versions.
- Choose an ODBC data source. In this case, an Oracle8 ODBC driver is selected.
An account name and password (warehouse in this case) is also selected.
- Finally, a physical level database diagram is displayed. Notice the indications pk and fk indicating which columns participate as primary keys and foreign keys.