By default, when you move to the Mapping tab of the Data Comparison wizard, Studio for SQL Server automatically maps all available objects of the selected databases.
Note
To remap already mapped objects, unmap them first. See the How to unmap an object section below.
Note
After objects are mapped for comparison and synchronization, you may encounter mapping warnings, displayed as Caution icons. For more information about mapping warnings see the Mapping Warnings topic.
1. Switch to the Mapping page of the Data Comparison wizard.
2. In the grid, select database objects to unmap. To find a mapped database object quickly, use the Filter box. Type the string in this box to view only the objects, containing this string in their names. Click the arrow button to select a recent search. To clear the Filter box, click the Close button.
3. Click the Unmap button on the toolbar.
The unmapped objects disappear from the grid, but will be listed in the Object Mapping dialog.
1. Switch to the Mapping page of the Data Comparison wizard.
2. Click the Map Objects button on the toolbar. The Objects Mapping dialog will appear.
Note
Actual document look may slightly vary from the above image depending on the product you use.
3. Select source and target objects in the corresponding boxes.
4. Click the Map button and the mapped objects disappear from the Objects Mapping dialog and will be shown in the Mapping tab’s grid.
5. Repeat steps 3-4 until you map all the objects you need. Click OK to close the dialog.
You can use this option to compare custom results received after query execution instead of comparing whole tables or views. For this, you should:
1. Click the Custom Query button on the Mapping page of the wizard. The Custom Queries Mapping dialog box will open.
Note
Actual document look may slightly vary from the above image depending on the product you use.
2. Select the Query or Table radiobuttons for source and target.
3. If you selected Table for both, refer to the How to map an object section of this topic. If you selected Query for Source, Target or both, write query name in the field (if the name assigned by default is not appropriate).
4. Type the needed query in the SQL field.
5. Click Validate to validate your queries, if necessary.
6. Click Map.
7. Click OK to close the dialog box.
Click the Cancel button to close the dialog and discard mapping.
Click the Reset button to restore the automatic mapping of objects.
Download dbForge Studio for SQL Server and try it absolutely free for 30 days!