Before working with tutorials, identify two data sources that you can use for practice. These data sources should not be live or mission-critical, and they should be similar in schema and data. |
Data comparison jobs automate the process of comparing and correcting data between data sources at the database, table, and row level. You select a source and a target data source from Data Source Explorer, map databases and tables between the two selections, and then run the comparison job.
DB Change Manager compares the information and returns a results screen with details including:
Once a data comparison job has run, you can then correct any synchronization issues by running an automatically-generated SQL script that adds missing rows and updates out-of-sync values. You can modify the SQL script prior to running it, and store it for future use.
To start Change Manager
When DB Change Manager first starts, it displays a Welcome screen. Review the Welcome screen options, and then close it.
In order to define and run jobs, you first register data sources by providing connection information and other details to DB Change Manager. Once a data source has been registered, it remains stored in a catalog and does not need to be reregistered each time you open DB Change Manager. You can use a single registered data source in multiple jobs.
Data Source Explorer shows the registered data sources and their associated jobs, if any. Before registering a data source, gather the information about the repository location and connectivity permissions.
To add a data source
Select the data sources you want to add to the DB Change Manager environment, and then click Finish.
The new data source or sources appear in the Data Source Explorer.
An alternative to using the Discover Data Sources wizard is to click File > New Data Source and set its connection properties. |
Prior to performing the following steps, make sure you have at least two data sources registered in DB Change Manager. Ideally these two data sources are similar in schema and content, so that the comparison is meaningful to you.
To create a data comparison job in the Overview tab
To customize the job in the Options tab
To refine comparisons in the Mapping tab
Select the databases you want to compare; usually they have the same or a similar name.
Use the All and None commands at the bottom of the pane to select all or none of the databases. |
Click Filter: edit while a pair is selected to use the Columns, Comparison Key, and Filter dialog and further refine the mappings, such as inserting a WHERE clause. |
To specify notifiers in the Notification tab
To run the job and see the results
| | | | | | | |