Working with Design Layers › Design Layers › New Design Layers › Split a Logical/Physical Data Model

Split a Logical/Physical Data Model

If you want to separate a logical/physical model into two models - a logical-only and a physical-only - you can use the Split Model option.

When you split a model, you are prompted to save the separate logical and physical data models with different names. When you save the new models, the logical model becomes the source of the physical model, which is necessary for synchronizing changes between the two model types. The original logical/physical model is preserved with its original name.

To split a logical/physical data model

1. Open a logical/physical model you saved previously.
2. Click Design Layers, Split Model on the Actions menu.

   The Split Model/Logical Save As dialog opens.

3. Save the logical side of the model with a new name.

   The Split Model/Physical Save As dialog opens.

4. Save the physical side of the model with a new name.

   Note: If you are using CA ERwin Data Modeler Workgroup Edition, and have established a connection to the database, you can choose to save your new models to the mart.

   The new logical and physical models, and the original logical/physical model remain open in the main workplace.