Choose Change Actions, Update From Database Wizard

This page allows you to choose database objects to synchronize with corresponding model objects.

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).

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.

Each node of the database object tree corresponding to the entity available to update has a remark which describes action raised between this model entity and corresponding database object. The following types of actions are available:

1.Added - means that this object isn't presented in the model. It will be added to the model after wizard finishing.
2.Dropped - means that this object isn't presented in the database. It will be added to the database after wizard finishing.
3.Changed - means some properties of this object are different with the corresponding database object fields. Model 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.

Use the context menu of the root nodes to check or uncheck all added, dropped or changed objects.

Group by databases

Select to group changed database 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.

 

ExpandedToggleIcon        See Also


Send feedback on this topic

© 2008 - 2024 Devart. All rights reserved.