Page History

...

CM/Schema > Archive Options

The Include Table Dependencies option extracts all table dependencies. By default, it is not selected.

You can specify defaults for how to extract DDL when the option is enabled in the Schema Archive Job editor.

• None means that DB Change Manager creates the archive in the development environment workspace. You can then extract the DDL directly from the archive.
• One File means that DB Change Manager exports the objects of the archive job to a single .SQL file, in addition to building the archive in the development environment. You can locate the SQL file in the Project Explorer.
• Multiple Files means that DB Change Manager exports each object of the archive job into individual .SQL files, in addition to building the archive in the development environment. You can locate the SQL files in the Project Explorer.

The Automatic Purge Options delete archive files after a number of days, number of versions, and/or when the size of the files reaches a certain limit. The purge conditions are checked and enforced when an archive job is saved or when a new version is created.

• The number of Days after which archives are deleted.
• The number of Versions stored, after which the oldest version is deleted.
• The number of MB total size of the version files, after which the oldest version is deleted.

Once you configure the preferences, click Apply.

CM/Schema > Comparison Options

...

Anchor
CMSchemaCompareOptionsIncludeObjectsOptions CMSchemaCompareOptionsIncludeObjectsOptions

CM/Schema > Comparison Options > Include Objects Options

The Include Object Options settings determine what elements of the job source and target will be included or omitted when running a schema comparison job and synchronization. The list of options differs depending on the DMBS of the source and target data sources.

These options include:

• The Exist in Source Only (Create) option specifies that objects only existing on the source appear in the job results.
• The Exist in Source and Target and Don’t Match (Alter) option specifies that objects that differ between the source and the target appear in the job results.
• The Force Extended Alter option specifies that the synchronization process always drops and recreates objects that don’t match instead of using an ALTER statement on existing objects.
• The Include Table Dependencies option indicates that table dependent objects are included in the generated DDL.
• The Exist in Target Only (Drop) option specifies that objects only existing on the target appear in the job results.
• The Generate Data Copy DDL indicates that data copy DDL is generated on extended ALTER statements in the automated synchronization script.

Anchor
CMSchemaCompareOptionsCompareOptions CMSchemaCompareOptionsCompareOptions

CM/Schema > Comparison Options > Compare Options

Compare Options settings affect how objects are treated in the comparison process. You can include or exclude specific object types in the job, and specify the behavior of the comparison job and synchronization scripts.

These options include:

• Ignore Storage ignores storage comparison when running the job.
• Ignore Partition Differences (Oracle only) ignores partition differences when running the job.
• Ignore Column Order ignores table column order differences when running the job.
• Ignore Check Constraints Quotes ignores quotes in check constraints when running the job.
• Ignore Table Comment ignores table comments when running the job.
• Ignore Text Case ignores syntax case in text object comparisons when running the job. (views, procedures, trigger, etc.)
• Ignore Text Comments ignores comments in text objects when running the job.
• Ignore Text Whitespace ignores white space when running the job.
• Ignore Tablespace File Name ignores tablespace file names when running the job.
• Ignore Password Differences ignores differences in object passwords when running the job. (group, login, role, user, etc.)
• Ignore Tablespace (IBM only) ignores tablespaces for table, index, cluster, etc.
• Ignore Object Permissions ignores the permissions on objects when running a job.
• Ignore Logging/No Logging Differences (Oracle only) ignores object differences where one is set to Logging and the other is set to No Logging.
• Ignore Sequence Start Value (Oracle only) ignores the Start Value property of an Oracle Sequence.
• Ignore Data Capture (IBM only) ignores the Data Capture property for tables.
• Ignore File Group (SQL Server only) ignores the File Group property for tables and indexes.
• Ignore Segment (Sybase only) ignores the Segment property for tables, indexes, and partition definitions.

Anchor
CMSchemaCompareOptionsDecoratorOptions CMSchemaCompareOptionsDecoratorOptions

CM/Schema > Comparison Options > Decorator Options

...