This page allows you to choose change actions for applying to the database. You also can choose database object changes for synchronization separately.
Choose Action
Select the objects and changes to synchronize in this tree. Each object contains the list of changes. Objects are grouped into object kinds (Tables and Views and Procedures and Functions) and by schemas (by default).
The context menu of the root nodes allows checking or unchecking all added, dropped or changed objects.
The box below the Choose Actions tree lists changes to the selected object.
In case you choose not to apply changes to some column or constraint, Entity Developer will 'remember' it and next time will not offer to apply changes to this object, i.e. in the Choose Actions tree the object will be deselected by default.
Group by databases
Select to group changed objects by schemas.
Each node of the object tree corresponding to the database object available to update has a remark which describes action raised between this object and corresponding model entity. The following types of actions are available:
| 1. | Added - means that this object isn't presented in the database. It will be added to the database after wizard finishing. |
| 2. | Dropped - means that this object isn't presented in the model. It will be dropped from the database after wizard finishing. |
| 3. | Changed - means some properties of this object are different with the corresponding database object fields. Database object field set will be changed. |
| 4. | Renamed - means that objects in the database and in the model have different names. This type of changes is not always detected automatically during the process of comparison of database metadata and metadata built on the basis of the model. For the renamed objects to be detected, they must conform to certain rules. Metadata comparison is implemented in two steps. In the first step equivalents are looked for, having exactly the same number of columns and foreign keys, and the columns themselves match as well; if no equivalents are found, then similar objects are looked for according to the same rules, but columns must match only in the matter of names. If identical objects are found, similar objects will not be looked for. If objects are not detected as renamed automatically, they are displayed as a pair of dropped/created objects. You need to select such pair, right-click the selection, and choose Resolve Renamed from the popup menu to mark the objects as renamed. In order to cancel renaming, right-click the object marked as Renamed and select the Cancel Renaming option. |
