You can create a schema comparison job to capture, compare, and synchronize database schemas. In addition, you can compare a schema against an archived version of a schema. For more information, see Creating a schema archive.
The following tasks step you through creating and running a schema comparison job:
After comparing the data, you can synchronize it to match; see Synchronizing Data Repositories.
Create or Open a Schema Comparison Job
You create, modify, and run a schema comparison job in the Schema Comparison Job editor.
To create a new schema comparison job
- Select File > New > Schema Comparison Job. The Schema Comparison Job editor opens.
To open an existing schema comparison job
- Select File > Open Job. Select a job from the list, and then click OK. The Schema Comparison Job editor opens.
Describe and Save the Schema Comparison Job
The Job Name and Description pane shows where the job is stored in Project Explorer. When you click the Details button, you can see the project’s file directory path.
If the job is used to monitor compliance against company standards or policies, you can add it to the Compliance Explorer list. This list lets you quickly see all the jobs that have recently passed or failed the compliance criteria you set.
To describe and save a job
- Type a new name for the job in the Name field. Enter a meaningful name that will quickly and uniquely identify the job in other views and dialogs.
- Add relevant information in the Notes field.
- Click Track Results in Compliance Explorer if you want the job to be listed in the Compliance Explorer.
- Click File > Save or File > Save All, or highlight the editor window, and then press Ctrl+S.
Specify a Schema Comparison Source and Targets
The Schema Comparison Source and Schema Comparison Target panes identify what data sources or schema archives are compared when the job runs. The Schema Comparison Job editor displays the Name, Type, and Host of the source and target.
You can also use a schema archive in a schema comparison job, to compare an older schema against a new one. For more information, see Creating a schema archive.
In addition, you can use the following radio buttons to specify whether to compare the current properties of the live data source, or an archived set of properties previously stored in DB Change Manager.
- Select Use Live Sources to compare the current properties of the data source when the job is executed.
- Select Use an Archive, and then select the schema archive and version from the pulldown menu.
To add a data source to a schema comparison job
- Click and drag a data source from Data Source Explorer to the Schema Comparison Source or Schema Comparison Target box, or click Change Data Source, and then choose a data source from the dialog box.
To add a schema archive to a schema comparison job
- Click and drag a schema archive from Data Source Explorer to the Schema Comparison Source or Schema Comparison Target box.
To change a schema archive or data source in a schema comparison job
- Click Change Data Source in the appropriate box, and then select a new data source from the dialog; or drag a different data source from Data Source Explorer to the box.