Transforming a logical data model into a physical data model

Use the Transform to Physical Data Model wizard to transform a logical data model into a physical data model.
Prerequisites:

To transform a logical data model into a physical data model:

  1. 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.
  2. Click Data > Transform > Physical Data Model from the main menu. As an alternative, you can click the Transform to Physical Data Model toolbar button Transform to Physical Data Model toolbar button icon on the main toolbar.
  3. 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.
  4. Complete the remaining steps of the wizard.
If you selected to create a new physical data model, the physical data model is created and displayed in the Data Models folder of the data design project that you specified. If you selected to update an existing physical data model, the compare editor opens so that you can merge changes.

Feedback