1.Transform from Logic model to physical model:
Project --- Data Model (Not Data diagrams) -- Select the logic model --- Data (Menu) -- Transform --Physical Model
Use the Transform to Physical Data Model wizard to transform a logical data model into a physical data model.
Prerequisites:
- Analyze your logical data model to ensure that it is valid before you transform it.
- Set logical data model properties that control transformation results.
To transform a logical data model into a physical data model:
- Select a logical data model or a logical data model object in the Data Project Explorer. You can transform from an .ldm file, a package, or an entity.
- Click Transform to Physical Data Model toolbar button
on the main toolbar.
from the main menu. As an alternative, you can click the - On the first page of the wizard, specify whether to create a new physical data model or update an existing physical data model. If you select to create a new physical data model, you can select a template to use on the next pages of the wizard. You can use a provided template or you can use a template that was exported from an existing physical data model. The resulting physical data model is a copy of the template with the addition of elements that are generated by the transformation.
- Complete the remaining steps of the wizard.