When you create a comparison project and you have selected your data sources, SQL Compare automatically maps objects with the same name and the same owner (SQL Server 2000) or schema (SQL Server 2008 and SQL Server 2005) for you.
If you want to compare objects with the same name, but those objects have different owners or belong to different schemas, you can map the owners or schemas as required. For example, if you want to compare objects in a test database that are owned by sales with objects in a production database that are owned by support, you can map sales to support.
Editing the owner mappings
The Owner Mapping tab of the Project Configuration dialog box enables you to edit mappings:
The upper pane displays a list of schemas, database roles, and database users that SQL Compare has automatically mapped for you; the lower pane displays a list of schemas, database roles, and database users that are not mapped.
- To undo a mapping, in the upper pane, select the mapping, and click Unmap.
- To create a mapping, in the lower pane, select item A from the source, then select item B from the target, and click Map.
Next, select item B from the source, then select item A from the target, and click Map.
For example, to map sales to support, you create a mapping for sales to support and then you create a mapping forsupport to sales.
To reset the mappings to the defaults, click Restore Default Mappings.