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 will be 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 press Ctrl+S.