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 using the following options:
- Ignore Case indicates that objects are analyzed without regard to case. For example, the table Product_Prices is compared to the table PRODUCT_PRICES.
- Ignore Spaces indicates that spaces are ignored when analyzing objects. For example, the table Product Prices is compared to the table ProductPrices.
- Ignore Underscores disregards underscores in object names for comparison purposes. For example, the table Product_Prices is compared to the table ProductPrices.
- Include Views indicates that the comparison process 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.
For more information, see Customize Database Mapping.
Comparison Options
The Comparison Options specify how the job handles naming conventions:
- Ignore Case indicates the job ignores case when comparing data. For example, Apple matches a corresponding value of apple.
- Trim Trailing Spaces indicates the job comparison ignores extra spaces at the end of values when comparing data. For example, Apple matches a corresponding value of Apple.
- Match Empty Strings with Nulls indicates that the job comparison considers empty values to be the same as null values for matching purposes.
- Cache Long Datatype Values indicates that long data types (blob, clob, varchar(max), etc.) values that do not match are cached during comparison and available for resolution during that stage of the process. When this value is disabled, the results of the job indicate that the values did not match but resolution is unavailable. Individual long datatype values can be retrieved when exploring results regardless of the selection of this property.
- Check Rows from Source checks the rows that exist in the source tables. If the option is not selected, the rows that exist on the source tables are not included in the comparison.
- Check Rows from Target checks the rows that exist in the target tables. If the option is not selected, the rows that exist on the target tables are not included in the comparison.
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
...