Schema Compare for Oracle

Setting project options

Project options change the comparison and deployment behavior of Schema Compare for Oracle. For example, you can set a project option to ignore certain differences between objects when you run a comparison.

To set project options:

  1. Open the Project Configuration dialog box.
    • To set options for a new project, on the toolbar, click New.
    • To set options for a saved project, on the toolbar, click Open, select a project, and click Open.
    • To review comparison results for an open project, on the toolbar, click Edit Project.
  1. On the Project Configuration dialog box, click the Options tab. This tab lists available project options:
  2. For each option you want to set, select its check box.

To search for an option, type search text in the Find box. The list of options is filtered to display only options that contain the search text.

The options you set are saved for each project. For more information on projects, see Working with projects.

Schema Compare for Oracle project options

Behavior

Include deployment script header

Includes a comment header at the top of deployment scripts. The header includes:

  • the date and time the script was created
  • the Schema Compare for Oracle build number used to create the script

Force column order

If deployment requires additional columns to be inserted into the middle of a table, this option forces a rebuild of the table so that column order is preserved following deployment.

The table is rebuilt in four steps:

  1. A new table is created.
  2. Data from the original table is copied into the new table.
  3. The original table is dropped.
  4. The new table is renamed as the original table.

Use forward slash

Terminates each statement in the deployment script with a forward slash.

Include SET SQLBLANKLINES ON

Adds the SQL*Plus command SET SQLBLANKLINES ON to the top of the script, so blank lines and new lines are interpreted as part of a SQL command or script.

Include SET DEFINE OFF

Adds SET DEFINE OFF to the top of the script file, so substitution values aren't used when running the script.

Exclude schema names

Excludes schema names from the deployment script.

Detect renamed columns

Attempts to detect renamed columns by matching the strings, position in the table, and datatype.

A possible renamed column will be identified if any of the following apply (in order of priority):

  1. The names are the same (case-insensitive)
  2. The target column contains the whole of the string source (eg "Company" in "CompanyName")
  3. The columns are the same ordinal and type, and the names are similar
  4. The columns have the same type, and the names are similar
Detecting column renames isn't completely reliable. Some renames won't be identified, and there may be some false positives.

Add PURGE clause to all table drops

Immediately releases the space assocaited with dropped tables, instead of moving tables and their dependents into the recycle bin.

If this option is selected, you won't be able to recover dropped tables.

Suppress dependent ALTER COMPILE (experimental)

Turns off all calculations and scripting associated with performing an ALTER COMPILE on objects that are dependent on those that are deployed. Use with caution.

Ignore options

Ignore slow dependencies

Ignores certain dependencies that affect comparison performance when comparing databases. The following dependencies are ignored:

  • type objects in your schema that are referenced by an object in another user's schema
  • REF constraints in your schema that reference or are referenced by objects in another user's schema
If this option isn't selected, all dependencies will be read and comparisons may be slow.

Ignore dependent objects in other schemas

Ignores calculating dependent objects in schemas that haven't been explicitly selected for comparison.

If this option isn't selected, dependencies will be calculated across all schemas, and comparison may be slow.

Ignore white space

Ignores white space (newlines, tabs, spaces, and so on) in object SQL creation scripts when comparing databases.

White space won't be ignored when the databases are deployed.

Ignore case differences in PL/SQL blocks

Ignores case differences in object SQL creation scripts when comparing databases. For example, if you turn this option on, MYTABLE and mytable aren't considered different table names.

Case differences in strings and double quoted identifiers aren't ignored. Case differences won't be ignored when the databases are deployed.

Ignore double quotes in PL/SQL blocks

Ignores double quotation marks (" ") around identifiers when comparing databases.

Double quotation marks won't be ignored when the databases are deployed.

Ignore external table location information

Ignores external table location information when comparing tables.

Ignore comments in PL/SQL blocks

Ignores comments in PL/SQL blocks when comparing databases.

Comments won't be ignored when the objects are deployed.

Ignore comments on tables, views and columns

Ignore comments on tables, views and columns when comparing databases.

Comments won't be ignored when the objects are deployed.

Ignore constraint names

Ignores the names of foreign keys and primary keys, and default, unique, and check constraints when comparing databases.

Constraint names won't be ignored when the databases are deployed.

Ignore index names

Ignores index names for comparison. If two indexes only differ by name, they will be considered identical when compared.

Ignore storage

Ignores storage properties (physical properties and partitioning clauses) on tables when comparing and deploying databases.

Table organization (heap-organized or index-organized) won't be ignored.

Ignore parallel

Ignore differences in the parallel clause on indexes and tables.

Ignore sequence current value

Ignores the current value of sequences when comparing and deploying databases.

If this option is turned on and you deploy a sequence, the current value of the target sequence is retained.

If the current value of the target sequence isn't within the MINVALUE and MAXVALUE limits of the source sequence, the current value is reset to a default value.

If this option is turned off and you deploy a sequence, the current value of the source sequence is used as the current value for the target sequence.

Ignore permissions

Ignore differences in object permissions.

Ignore log groups

Ignores supplemental log groups when comparing tables.

Ignore materialized view START WITH value

Ignores materialized view START WITH value.

Ignore character length semantics

Ignores length semantics differences for columns.

CHAR and VARCHAR2 columns are stored as CHAR or BYTE depending on the server configuration (NLS_LENGTH_SEMANTICS) or column specification. Normally, if a particular column is stored as CHAR in one schema and BYTE in another, Schema Compare will treat this as a difference.

If this option is set, Schema Compare will not treat it as a difference.

Include storage options

Include all storage options

Includes all storage properties (physical properties) on tables and indexes when comparing and deploying schemas.

When this option is selected, all possible storage clauses are compared and scripted, and all other "Include storage" options are ignored.

Default options

To save your option settings as the default options for all new projects, click Save as My Defaults. To revert to your default settings after making changes, click My Defaults.

To reset all the options to their original settings, click Red Gate Defaults. This turns on the following options:

  • Include deployment script header
  • Ignore slow dependencies
  • Ignore white space
  • Ignore case differences
  • Ignore double quotes
  • Ignore comments
  • Ignore constraint names
  • Ignore storage
  • Ignore sequence current value

Didn't find what you were looking for?