The View Mapping Rules step allows you to define how data compare should perform the name-matching of the database views. By default, views with the exact name, on both schemas, are paired with one another and compared. You can use mapping rules if your schemas have views that do not have the exact name, but are different in a consistent way. If there are views in the development environment, whose name starts with V_DEV_, but in production the same views start with V_PROD_, then you can use the following mapping rule to map them. Without the mapping rule, these views will be excluded.

The wizard steps related to views are disabled by default. To enable them, check the comparison option Compare and synchronize views.

The following fragment is the xml generated for this mapping rule:

<ViewsMappingRules>
  <NameMapping MappingRule="IgnorePrefix" IgnoreLeftName="V_DEV" IgnoreRightName="V_PROD" />
</ViewsMappingRules>


IDERA |  Products | Purchase | Support |  Community |  Resources |  About Us  | Legal
  • No labels