The following topics describe preferences specific to DB Change Manager:
CM/Config > Archive Options
You can set this option to take effect whenever you create a new configuration archive job:
Extract DDL
By default, a new configuration archive does not include DDL. If you want each new archive to include the DDL, check this box, and then click Apply.
CM/Config > Comparison Options
You can set this option to take effect whenever you create a new configuration comparison job:
Extract DDL
By default, a new configuration comparison does not include DDL. If you want each new comparison to include the DDL, check this box, and then click Apply.
CM/Data > Comparison Options
The Comparison Options defaults correspond to the job options listed on the Options tab of the Data Comparison Job editor. For more information, see Specify Execution, Mapping, Comparison, and Resolution Options.
Data comparison options are grouped into these categories:
Execution Options
Execution Options control aspects of processing the job:
- Automatically Synchronize indicates that the job automatically attempts to synchronize any issues it finds between the source and target data sources upon completing comparison execution. If you leave this option unchecked, you can generate a synchronization script at a later point, after job completion.
Compression Comparison speeds up a job by compressing row data for faster transmission and comparison. The compression does not affect the accuracy of a job. This option is useful with slow networks, with large volumes of data in each row, and with faster database servers.
Compression Comparison is not available for Sybase.
- Optimize comparison based on row length. The value determines when compression is applied on a table during the data comparison process, based on the total size of all of the rows. If the size of the rows is greater than this value, then compression is automatically enabled.
- Generate DML indicates that the synchronization DML used in the job is automatically placed in a separate file. If this option is selected, you can specify on the Notifications tab to send the resulting output with any notification.
Mapping Options
Mapping Options control how the data sources in the job are mapped to each other:
Ignore Case indicates that objects are analyzed without regards to case. For example, the table “Product_Prices” will be compared to the table “PRODUCT_PRICES”.
Ignore Spaces indicates that spaces will be ignored when analyzing objects. For example, the table “Product Prices” will be compared to the table “ProductPrices”.
Ignore Underscores disregards underscores in object names for comparison purposes. For example, the table “Product_Prices” will be compared to the table “ProductPrices”.
Include Views indicates that the comparison process will include views during the mapping process. If this option is not selected, views are automatically excluded from the comparison.
Exclude Computed Columns indicates that the comparison does not include columns whose values are computed in the mapping and comparison processes.
See Customize Database Mapping for more information about these options.
Comparison Options
...
Resolution Options
...
CM/Data > Data Result Options
...
CM/Data > General
...
CM/Data > Mapping Validation
...
CM/Data > Script Generation
...
CM/Schema > Archive Options
...
CM/Schema > Comparison Options
You can set the default job options for schema comparison jobs. Choose a database tab and then select the check box of the appropriate job option to indicate that it is on by default.
The list of options differs depending on the DMBS of the source and target data sources. The parameters in the panel correspond to the job options listed on the Options tab of the Schema Comparison Job Editor. The option categories include:
After you reconfigure any options, click Apply.
CM/Schema > Comparison Options > Include Objects Options
...
CM/Schema > Comparison Options > Compare Options
...
CM/Schema > Comparison Options > Decorator Options
...
CM/Schema > Comparison Options > Identifier Options
...
CM/Schema > Comparison Options > DDL Extract Options
...
CM/Schema > Comparison Options > Additional Options
...
CM/Schema > General
...
CM/Schema > Mapping Options
...
CM/Schema > Refinements Options
...
Command Line
...
Compliance
...
Label Decorations
...
Notification > Email Notification
...
Reports
...