Use the New Physical Data Model wizard to create a new
physical data model.
Before you begin
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.
Procedure
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.