Page History
...
| Anchor | ||||
|---|---|---|---|---|
|
Decorator Options affect particular database objects.
...
| Anchor | ||||
|---|---|---|---|---|
|
...
...
...
...
The Identifier Options panel contains parameters that determine what elements of the source and target data source are ignored during the schema comparison and synchronization process.
These options include:
- The Ignore Name Case option specifies that the syntax case is ignored when doing comparisons. This option is deselected by default.
- The Ignore Constraint Names option specifies that differences in table constraint names are ignored when doing comparisons. This option is deselected by default.
- The Ignore Specific Name (IBM DB2 for LUW only) option ignores SQL specific names in procedures, functions, and methods. This option is deselected by default.
| Anchor | ||||
|---|---|---|---|---|
|
The DDL Extract Options section contains the Extract DDL parameter. When it is selected, the DDL code appears separate editor window after the comparison job runs. This option is deselected by default.
| Anchor | ||||
|---|---|---|---|---|
|
Additional comparison options are listed at the bottom of the list of preferences.
These options include:
- Enable Dependency Linking. When this option is activated, the comparison contains information about dependencies between objects. This information is critical for the ordering of the generated DDL. If the option is not enabled, the schema comparison is faster but when DDL is generated for more than one object, the ordering is incorrect. By default, Enable Dependency Linking is deselected for Oracle, so all
GRANTstatements for Oracle objects are not extracted and compared.
CM/Schema > General
The General options relate to schema comparison jobs:
- Show uncomment alter tablespace script confirm dialog. There is an alter tablespace script confirm dialog that displays by default. Deselect this option if you do not want to see this dialog.
- Do not ask about running the created jobs. Select this option if you want to ignore the system prompt when running schema comparison jobs. If you select this option, you can also select whether to automatically run a schema comparison job when an object is created.
- Automatically launch jobs created from selected objects. Select this option if you want to automatically run a schema comparison job when an object is created.
Once you configure new defaults, click Apply.
CM/Schema > Mapping Options
You can specify the default mapping job options available on the Mapping tab of the Schema Comparison Job editor:
- Ignore Case. By default, schema comparison jobs ignore the case of the texts. Deselect this option if case is important to you.
- Ignore Spaces. By default, schema comparison jobs ignore spaces in the texts. Deselect this option if spaces are important to you.
- Ignore Underscores. By default, schema comparison jobs compare underscores in the texts. Select this option if you do want to ignore underscores.
- Show Users. (Oracle only) By default, schema comparison jobs show users from the source and target that have at least one object. Select this option if you want to show all users from the target, regardless of whether they have any objects in their schema, and map them with users from the source.
Once you configure new defaults, click Apply
...
CM/Schema > General
...
CM/Schema > Mapping Options
...
| Anchor | ||||
|---|---|---|---|---|
|
...