Defining a physical data model based on reverse engineering

You can use the New Physical Data Model wizard to define a physical data model based on reverse engineering from a database or DDL file.

The database must have a connection profile defined in the Data Source Explorer.
To define a physical data model based on reverse engineering:
  1. Click File > New > Physical Data Model from the main file menu. The New Physical Data Model wizard opens.
  2. On the Model File page, specify the database, version, and location of the new model file.
  3. Select Create from reverse engineering.

    If you choose to reverse engineer from a database, you must provide connection information on the next pages of the wizard. If you choose to reverse engineer from a DDL file, you must provide the path to a DDL file in the next pages of the wizard.

  4. Complete the steps of the wizard.

The physical data model is created and displayed in the Data Models folder.