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
The Resolution Options section determines how the job resolves any discrepancies discovered during the comparison process.
- Drop and Recreate Foreign Keys indicates that all foreign keys are dropped prior to applying changes during the resolution process. This option should be used with Wrap Statements in Transaction to ensure that foreign keys do not remain dropped in the event that the synchronization script used to resolve it fails.
If this option is not selected, a data comparison job generates ordered table insert and delete statements, and you must do the following tasks:- In the Mapping page, select all dependent tables. If a referenced table is missing from the comparison, DB Change Manager cannot ensure the referential integrity of the data.
If you also change the comparison key, you must set the same column as a comparison key for all dependent tables. If you do not do so, DB Change Manager cannot insure the referential integrity of the data.
This option is only available for SQL Server scripts.
Wrap Statements in a Transaction utilizes a transaction and rolls back any repository changes if it encounters an error.
This option is not supported for DB2 for LUW scripts.
- Enable Identity Column Inserts and Updates enables changes to identity column values on SQL Server and Sybase platforms. The update and insert statements are automatically included in the synchronization script when this option is selected.
CM/Data > Data Result Options
The Data Result Options affect how data comparison results are processed:
Cache options. The Comparison Result Cache Location specifies the directory path of the result cache, where job data is captured. Use the Default Location, or de-select it, and then browse to a new directory location.
This is a temporary cache. Large data comparison jobs may require many system resources.
Refresh Interval. The Data Movement Progress Refresh Interval determines how quickly the progress of the data comparison is updated, in seconds.
CM/Data > General
The General options relate to data mapping:
- Remembered dialog decisions. When you select a default masking rule on a database or table, this option affects the masking rule used on the corresponding tables or columns. Yes means the rule is used on all. No means the tables or columns use the rule set explicitly for them. The default Prompt allows you to make the decision at the time you select the masking rule on the database or table.
- Don’t show again decisions. When the Automatically Synchronize option is toggled, some mappings become invalid and are removed. If you want to see this information, select this box.
CM/Data > Mapping Validation
DB Change Manager performs a variety of validation checks when it compares or synchronizes data. You can specify severity responses for mapping validation checks on comparison and synchronization jobs. By default, some checks always indicate an error. For other checks, you can configure the response.
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
...