Running Synchronization (Physical > Logical)
To start the synchronization:
1. Select the database concerned (in the list of databases or in a diagram for example).
2. Right-click the database and select Synchronize.
The synchronization wizard opens.
3. Select the synchronization type "physical to logical".
Step 1: Selecting objects to be synchronized
To define synchronization scope:
Scroll the list of objects contained in the database.
1. By default, all objects are selected and therefore included in synchronization. To exclude an object from the synchronization, clear it from the Scope column. When an object is excluded, its mapping is also excluded.
2. By default, all the objects are "realized", in other words, they give way to the creation of an object during synchronization. To specify that an object is "not realized", select it in the Not realized column. For more detailed information, see Realized mode.
3. When the list of objects has been defined, click the Next in the wizard.
Step 2: Synchronization options
From the synchronization options, you can:
• Reinitialize target objects: synchronization starts from zero and deletes existing target objects.
• Recalculate target object names: names of data diagram objects are recalculated as a function of those of the relational diagram. This means that any manual modification of the data diagram is canceled.
• Take account of optimizations: all optimizations - including those not selected in the validation step (see Validating optimizations) are proposed.
• Take account of deletions: entities, associations and diagrams that have been deleted are included in the scope. Consequently, deletion of corresponding target objects and links is proposed.
You must also indicate the data model that will own the set of objects created by the synchronization.
Other options concern target object properties update. By default, synchronization updates all properties of each object concerned.
Scheduling
You can run synchronization:
• Immediately
• As soon as possible (after publication of updates)
• At a predefined date and time
When options have been specified, click Next.Step 3: Protecting objects
Synchronization can impact all target objects.
To keep an object intact, select it in the Frozen.Click Next to continue.See Protecting Objects.
Step 4: Validating results
The wizard displays the results that will produce synchronization validation.
To validate these results, click Next.A report presents a list of processes that have been carried out.
See also:
Reduced synchronization
The above synchronization applies to a database but you can also run a Physical > Logical synchronization on a specific object of the database to reduce synchronization scope and processing time. See Reduced Synchronization (Logical to physical mode).