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:
- Create 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.