Diagram Synchronization
Synchronization enables translation of a logical data model to a physical model, and vice versa. Before running synchronization, source diagrams (data diagrams and physical diagrams) must be saved and closed.
A first synchronization automatically creates the target model diagram. A new synchronization on previously synchronized models does not include automatic update of diagrams, in other words of graphical representation of models. Depending on the changes you have made, the synchronization wizard may propose update of the target diagram.
Case of Diagram Update at Synchronization
The synchronization wizard proposes diagram update in the following cases.
After source diagram modification
When you run synchronization after source diagram modification, by default the wizard activates target diagram update. Updating is indicated by display of two small blue arrows.
Below, at synchronization in logical to physical mode, modification of the logical diagram automatically produces a physical diagram update.
After target diagram modification
If you have modified the target diagram, for example the physical diagram, by default the synchronization does not propose update of this target diagram.
To display the case of target diagram update, you must select the synchronization option "Take account of optimizations". So that the update will be activated, you must select the check box in question.
After modification of both diagrams
If both diagrams - logical and physical - have been modified, target diagram update is proposed but not selected by default.
No modification detected
If neither of the two diagrams has been modified, the wizard does not propose update. It should be noted that any diagram modification must be saved before closing the diagram so that it will be taken into account by the synchronization wizard.
Particular case: an entity mapping with two tables
When an entity of the logical model is associated with two tables in the physical model (following merging of entities for example), the updated physical model displays only one of the tables.