You can create a data comparison job to compare the data of two registered data sources, specify configuration adjustments and refine mapping parameters. After running the job, DB Change Manager can generate SQL scripts which you can run to synchronize any discrepancies. You can run the scripts to update data sources immediately, or store the scripts for later use.
DB Change Manager displays data comparison job results at row level, and it can automatically update mismatches or add missing rows at the table level.
The following tasks step you through creating and running a data comparison job:
- Describe and Save the Job
- Specify the Source and Target Data Sources
- Specify Execution, Mapping, Comparison, and Resolution Options
- Understand the Data Source Mapping Process
- Customize Database Mapping
- Inspect the Databases
- Optionally Reconfigure the Data Source Mapping
- Optionally request email, logs, or system tray notifications (see Setting job notifications)
- Run the Data Comparison Job
- Review Comparison Results
- Optionally generate a job report (see Creating a job report)
After comparing the data, you can synchronize it to match; see Synchronizing Data Repositories.
Create a Data Comparison Job
You create, modify, and run a Data Comparison job in the Data Comparison Job editor. For more details about the editor, see Data Comparison Job Editor in the User Interface Reference.
To create a new data comparison job
Select File > New > Data Comparison Job and the Data Comparison Job editor opens.
To open an existing data comparison job
- Select File > Open Job.
- Select a data comparison job from the list.
- Click OK.
The Data Comparison Job editor opens.