In most cases the default mapping mechanism that pairs the objects based on the schema name and the object name is what is needed. However, there are often scenarios in which the same table may be owned by different schemas in different databases, or the tables on the development server for example may have the names prefixed with dev_ whereas the same tables in the production server do not have that prefix. In such cases you may want to define certain mapping rules that would allow you to pair objects that would otherwise not be paired together by IDERA SQL Data Compare.

The Mapping Rules can be accessed from the ribbon or from the action links on the right panel of the comparison tab.

There are three types of rules you can set:


 |    |  |   |   |   


Save

Save