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.
Once you create a baseline archive of your schema, you can compare it against the other schemas, even in live environments. Also, you can synchronize the schema of a data source with the archive using the Schema Comparison Job editor.
To define a schema comparison job
- Select File > New > Schema Comparison Job and if prompted, select a project.
- In the Schema Comparison Job editor, type the name of the job in the Name field.
- Drag and drop a data source from Data Source Explorer to the Schema Comparison Source box.
- Drag and drop a data source from Data Source Explorer to the Schema Comparison Target box.
- Click the Mapping tab.
- In the Mapping tab, review the object mappings that are already set up for you. Change the target mappings as needed.
- In the Options tab, select or de-select the configuration properties.
- Click the Run Job icon.
- In the Comparison Results tab, the job progress bar displays and the results appear. Review the job results.
To generate and run a schema synchronization script
- In the Comparison Results tab, click Generate Sync Script in the Resolution column of the Comparison Results table. DB Change Manager generates a synchronization script in the SQL Editor.
- Modify the script as needed, and save it using the File > Save command.
In the SQL Editor, select the Execute SQL icon to synchronize the data.
Executing the SQL script changes the schema in your target data source. Be sure to review all potential changes and read the script before running it.
- If you want to create a report, click Generate Report. The Export dialog opens and provides additional report options.