Use the Properties view to set the transformation properties
of entity objects before you transform a logical data model into a
physical data model.
Before you begin
Before you modify the properties of logical data model objects,
you must open a logical data model in the logical data model editor.
Procedure
To set entity transformation properties for logical to
physical data model transformation:
- Select an entity object in the Data Project Explorer or
in a diagram.
- Click to
open the Properties view, if the view is not already open.
- On the General page in the Properties
view, modify the Persistent property as needed.
If you select Persistent, the entity
is transformed to a table. If you do not select Persistent,
the entity is not transformed. The icon for the entity in the Data
Project Explorer or in data diagrams is changed to visually indicate
when it is not persistent.
You can set global preferences for
entity persistence on the Logical Data Model preferences
page. To set this preference, click , expand the Data
Management node, and click Logical Data Model.
The Persistent property for all new entities
that you create after you set this preference will be set according
to the global preference. Existing entities are not modified.
- On the General tab of the Properties view,
modify the Transform As property as needed.
If you select to transform as an XML column, XML columns
and the associated XML schemas are generated from the entity. Related
entity objects are also generated.
- Save the logical data model.