Use the New Physical Data Model wizard to create a new physical
data model.
Before you begin
Prerequisites: Before you create a physical data model by using
a wizard, you must create a data design project in the workbench.
About this task
In
addition to this method, you can also generate a physical data model from
a logical data model.
To create a physical model by using a wizard:
- Click from the main file
menu. The New Physical Data Model wizard opens.
- Complete the steps of the wizard.
You can create
a blank model or you can use a templates. If you have previously
created a physical data model template that you want to use for this physical
data model, you can enable the template for selection by specifying the location
of the template file in the next pages of the wizard.
You can also choose
to reverse engineer the model from a database or a DDL file. 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.
Results
The physical model is created and displayed in the
Data
Models folder under the data design project that you specified
in the Data Project Explorer.