Synchronization after Modifications to the Physical Diagram
Deleted table or column
If you delete objects from the database that were created by the synchronization (table, column, key, index...), these deletions are memorized and retained.
As long as the entity, association, or attribute that maps the table or column exists, the table or column is no longer recreated.
To recreate a column created by the synchronization and subsequently deleted:
1. Run database synchronization
2. At the results validation step, confirm the creation action (select the corresponding check box) proposed for this column.
Created objects
Objects (table, column, key, index) created in the relational diagram are retained.
However, deleting the objects they depend on may result in their deletion.
For example, a column is created in a table mapped by an entity. If the entity is then configured as “No table” or if the entity is disconnected from the datamodel, the corresponding table will disappear and the column with it.
Objects created in the relational diagram can be mapped manually. Objects created at synchronization are mapped automatically.Modified characteristics of objects created by synchronization
Modifications to the characteristics (SQL name, length, not null, datatypes) of objects created by synchronization are retained.
Modified order
Concerning modifications of order, processing depends on options defined in the synchronization wizard (see Step 2: Synchronization options).