Configuration comparison jobs compare the configuration settings between two registered data sources. They help you ensure consistency between the settings of two data sources in order to meet guidelines for data storage and retention.
Configuration comparison job results are presented as an overall “percentage matched” between two data sources. The results list individual configuration properties and details. The job shows:
You can create a configuration standard, which is a customized list of configuration parameters, values, and comparison operators, to compare against a data source. For more information, see Creating a standard for configuration settings.
You can also compare a data source or standard against an archive, which is a saved version of the configuration properties of a registered data source. For more information, see Creating a configuration archive.
The following tasks step you through creating and running a configuration comparison job:
All comparison jobs, archives, and standards provide version information with regards to each data source platform. For more information, see Version Information Reference.
You create, modify, and run a configuration comparison job in the Configuration Comparison Job Editor.
To create a new configuration comparison job:
Select File > New > Configuration Comparison Job. The Configuration Comparison Job editor opens.
To open an existing configuration comparison job:
The Job Name and Description pane contains more than just the Name field. It 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 you want the job 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
The Job Sources section of the Configuration Comparison Job editor specifies the data sources, archives, and standards to be compared. You can compare:
You can also compare a single source against multiple targets.
To add a data source to a job
Select Use Live Sources to compare the current properties of the data source when the job is executed.
You can change a data source selection by clicking Change Data Source from the appropriate box, or by dragging a different data source to the box from Data Source Explorer. |
To add a configuration standard to the job
To add a configuration archive to the job
To add multiple targets to the comparison job
When you are finished setting up the source and target or targets for the configuration comparison job, click Refinements to review the properties that are compared.
After you specify a comparison job source and its target or targets, you can customize the comparison properties using the Refinements tab of the Configuration Comparison Job editor.
To specify the properties used in the comparison job
After you have set the comparison properties, you can set the job options that pertain to how the job is executed.
The Options tab in the Configuration Comparison Job editor contains the Extract DDL option. If you select it, the synchronization code produced by the job comparison appears in a separate editor window when the comparison is done.
When a job completes, DB Change Manager provides various ways of notifying you. For more information, see Setting job notifications.
The configuration comparison job runs when you click the Run Job icon in the Configuration Comparison Job Editor.
While it runs, the Comparison Results tab appears and displays the progress of the job.
When a job is complete, the Comparison Results tab displays the results.
The Comparison Summary shows:
The Comparison Results table lists the details further down in the window.
Comparison Results includes:
After running a comparison job, you can create a job report using the View Report button on the Results tab. For more information, see Creating a job report.
If you want the configuration information to be the same between the source and target or targets, DB Change Manager can generate a script that will resolve the differences.
To create a SQL synchronization script
You can execute synchronization scripts in the SQL Editor. For more information, see SQL Editor.
To execute the SQL synchronization script
In the SQL Editor, click the Execute SQL icon. DB Change Manager executes the code on the target data source and displays the results.
| | | | | | | |