Setting Up Data Comparison

From this topic you will learn all steps that can be taken during data comparison process and alternative ways for accomplishing routine comparison tasks.

  1. To open the Data Comparison Wizard and start comparing data, click New Data Comparison on the Start Page.

  2. In the Data Comparison Wizard window, select source and target connection from the drop-down list. Also you can create a new connection by clicking New or modify existing ones by clicking Edit. You can easily swap source and target connections by clicking the Swap Target Swap button (to immediately compare the data, click the Compare button. To tune the comparison, click the Next button to move to other wizard pages).

  3. On the Options page, customize your comparison by checking the required options. Here you can generate a file with the command line arguments. Click Next.

  4. On the Mapping page, customize mapping. Use this page if you want to change the default mapping or map tables with different names or columns with different names and structure. Click Compare.

  5. After comparison process is completed, you can view results in the Data Comparison document.