Schema Compare for Oracle

Command line switches

/abortonwarnings:<warning level>

Aborts the deployment if there are any deployment warnings. You can specify none (default), medium, or high.

/activateserial:<serial number>

An internet connection is required to activate Schema Compare for Oracle from the command line.

For information about how to activate manually without an internet connection, see Activating.

Attempts to activate Schema Compare for Oracle.

You can specify a Schema Compare for Oracle serial number, or a serial number for bundle such as the Deployment Suite for Oracle:

sco /activateSerial:123-456-789012-ABCD

If you run the switch without specifying a serial number, the Activate Schema Compare for Oracle dialog box opens:

If you're using the Schema Compare for Oracle command line on a server, you need a DLM Automation Suite for Oracle license.

/behavior:<value>

This switch only works if you specify values for /source and /target.

Alias: /b

Specifies options that affect deployment behavior. For more information, see Setting project options.

The defaults are scriptheader, defineoff, and detectcolumnrenames.

Value Option
scriptheader h
forcecolumnorder f
forwardslash s
defineoff d
blanklineson b
excludetargetschema e
detectcolumnrenames r
purgedroptable p
suppressaltercompile c
Behavior options can be bundled (eg /b:de) or used in long format (eg /behavior:defineoff /behavior:excludetargetschema).

Specifying a value for /behavior/ignore, or /storage clears the defaults for /behavior and /ignore.

 For example, if you specify /b:f, the defaults /i:sdwqgva and /b:hdr no longer apply.

/deactivateserial

Attempts to deactivate the application. An internet connection is required to deactivate the product.

/deploy

Alias: /d

Deploys the source schema to the target schema. The target is modified. The source isn't modified.

Example

sco /project:"C:\Schema Compare for Oracle\Projects\WidgetDatabases.ocp" /deploy

If you're using /source and /target, all object differences are deployed.

If you're using a project file, only the selected object differences are deployed. To deploy all objects in a project file, use /deployallobjects.

/deployallobjects

Alias: /dao

This switch only works if you specify a value for /project.

Specifies that all object differences will be included in the deployment script, whether or not you selected them in the project.

Example

sco /project:"C:\Schema Compare for Oracle\Projects\WidgetDatabases.ocp" /deploy /deployallobjects

/deployscriptencoding:<encoding>

Alias: /depenc

Specifies the character encoding to use when writing the deployment script file. The default is UTF8.

Values

UTF8 UTF-8 encoding, without preamble
UTF8WithPreamble UTF-8 encoding, with 3-byte preamble
Unicode UTF-16 encoding
ASCII ASCII encoding

Example

sco /project:"C:\Schema Compare for Oracle\Projects\WidgetDatabases.ocp"
/scriptfile:"C:\Deployment Scripts\WidgetDeployment.sql"
/deployscriptencoding:ASCII

/direct

Forces the connection to use the internal Oracle client where possible. You can't connect via TNS name or service name using this option, but no Oracle client (eg Oracle Instant Client) is required.

/excludedependencies

Alias: /exd

Excludes dependent (referenced) objects from deployment.

/exclude:<behavior>

Alias: /exc

Excludes objects that are only in the source, only in the target, or that exist in both but are different.

Arguments

Missing exclude any object only in the source that would generate a CREATE statement
Different exclude any object in the source and target that is not equal, do not generate ALTER statements for these objects
Additional exclude any object only in the target that would otherwise cause a DROP statement

/filter:<filterfile.scpf>

Alias: /f

Excludes objects from deployment based on the filter file generated by Source Control for Oracle. If the file Filter.scpf exists in the scripts source directory, it will be used by default, unless you specify /deployallobjects.

If you're using a filter file to exclude a dependent (referenced) object, you also need to specify /excludedependencies. Otherwise, the default behavior to include dependencies overrides the filter, and the dependent object is included.

Note that you can't choose to include or exclude specific dependencies  you can only include or exclude all of them.

/help

Alias: /?

Displays help, with a list of all commands. Use in conjunction with /verbose for more detailed information. If this switch is used with any switches other than /verbose, those switches will be ignored.

/ignore:<value>

This switch only works if you specify values for /source and /target.

Alias: /i

Ignores specified items when comparing data sources. For more information, see Setting project options.

The defaults are slowdependencies, dependentobjects, whitespace, doublequotes, storage, sequencevalue, and mviewvalue.

Value Alias
slowdependencies s
dependentobjects d
whitespace w
casedifferences c
doublequotes q
sqlcomments m
objectcomments o
constraintnames n
indexnames x
storage g
parallel p
sequencevalue v
permissions r
loggroups l
mviewvalue a
externaltablelocation e
lengthsemantics t
Ignore options can be bundled (eg /i:qp) or used in long format (eg /ignore:doublequotes /ignore:parallel)

Specifying a value for /behavior, /ignore, or /storage clears the defaults for /behavior and /ignore.

For example, if you specify /i:x, the defaults /i:sdwqgva and /b:hdr no longer apply.

/includeidentical

Alias: /ii

Specifies that identical objects are also included in the report. For example:

sco /project:"C:\Schema Compare for Oracle\Projects\WidgetDatabases.ocp" /report:"C:\Reports\WidgetReport.html" /reporttype:Simple /includeidentical

/indirect

Forces the connection to use the installed Oracle client (eg Oracle Instant Client), so you can connect using a service name.

Specifying this option has the same effect as clearing the Prefer direct connection option in the Schema Compare Application Options.

/loglevel:<level>

Alias: /log

Creates a log file with a specified minimum log level. The default is none.

Log files collect information about the application while you're using it. These files are useful to us if you've encountered a problem. For more information, see Logging and log files.

Arguments

None

Disables logging

Error

Reports serious and fatal errors

Warning

Reports warning and error messages

Verbose

Reports all messages in the log file

Example

sco ... /loglevel:verbose
You must use  /loglevel each time you want a log file to be created.

/project:<project file>

Alias: /p

Specifies a saved Schema Compare for Oracle project file (.ocp) to compare. For example:

sco /project:"C:\Schema Compare for Oracle\Projects\WidgetDatabases.ocp"

/quiet

Alias: /q

Quiet mode - displays no output.

/report:<file name>

Alias: /r

Generates a report and writes it to the specified file. You can use the /includeidentical and /reportselectedobjects switches to customize the report. 

The type of report generated is defined by the /reporttype switch. For example:

sco /project:"C:\Schema Compare for Oracle\Projects\WidgetDatabases.ocp" /report:"C:\Reports\WidgetReport.xml" /reporttype:XML

If a file with the same name already exists in the location you specify, it will be overwritten.

/reportselectedobjects

Alias: /rso

This switch only works if you specify a value for /project.

Specifies that only objects selected in the project file in the graphical interface will be included in the report.

Example

sco /project:"C:\Schema Compare for Oracle\Projects\WidgetDatabases.ocp" /report:"C:\Reports\WidgetReport.html" /reporttype:Simple /reportselectedobjects

/reporttype:<report type>

Alias: /rt

Specifies the file format of the report produced by the /report switch. The default is XML.

Arguments

XML Simple .xml report
Simple Simple .html report
Interactive Interactive .html report
Excel Microsoft Excel .xls spreadsheet

For example, to create a simple HTML report:

sco /project:"C:\Schema Compare for Oracle\Projects\WidgetDatabases.ocp" /report:"C:\Reports\WidgetReport.html" /reporttype:Simple

/resolve:<issue>:<resolution>

Resolves script generation issues. For example:

/resolve:TargetUserDoesNotExist:Ignore

/scriptfile:<file name>

Alias: /sf

Generates a SQL deployment script which can be executed at a later time. For example: 

sco /project:"C:\Schema Compare for Oracle\Projects\WidgetDatabases.ocp"
/scriptfile:"C:\Deployment Scripts\WidgetDeployment.sql"

/scriptsfolder:<folder name>

This switch only works if you specify values for /source and /target.

Alias: /sfo

Creates a scripts folder to a specified location from the /source data source.

/snapshot:<snapshot file name>

This switch only works if you specify values for /source and /target.

Alias: /snp

Creates a snapshot of the /source data source, with the specified filename.

/snapshot1:<snapshot file name>

Alias: /snp1

This switch only works if you specify a value for /project.

Saves a snapshot of the source schema to the specified file. For example

sco /project:"C:\Schema Compare for Oracle\Projects\WidgetDatabases.ocp" /snapshot1:"C:\Snapshots\SourceSnapshot.snp"

If a file with the same name already exists in the location you specify, it will be overwritten.

/snapshot2:<snapshot file name>

Alias: /snp2

This switch only works if you specify a value for /project.

Saves a snapshot of the target schema to the specified file. For example

sco /project:"C:\Schema Compare for Oracle\Projects\WidgetDatabases.ocp" /snapshot2:"C:\Snapshots\TargetSnapshot.snp"

If a file with the same name already exists in the location you specify, it will be overwritten.

/source:<value>

Alias: /s

The data source and schema(s) to use as the comparison source. The schemas are compared in the order they appear.

Live without Oracle client:

user/pass@host[:port]/sid{SchemaA} [AS (Normal|SYSDBA|SYSOPER)] (/direct)

Live with Oracle client:

  • TNS name:
(user/pass|/)@tns{SchemaA, SchemaB} [AS (Normal|SYSDBA|SYSOPER)]
  • Manual connection:
(user/pass|/)@host[:port]/service{SchemaA, SchemaB} [AS ...] (/indirect)
  • LDAP
 (user/pass|/)@ldap{SchemaA, SchemaB} [AS ...]

Snapshot:

c:\snapshot.onp{SchemaA}

Scripts folder:

c:\ScriptsFolder{SchemaA}

/storage:<value>

Alias: /g

Includes storage options when comparing and scripting data sources. The default is none.

Value Alias
all a
lobs b
compression c
extents e
initrans i
logging l
pctfree p
tablespace t

 

Specifying a value for /behavior, /ignore, or /storage clears the defaults for /behavior and /ignore.

For example, if you specify /i:x, the defaults /i:sdwqgva and /b:hdr no longer apply.

/target:<value>

Alias: /t

The data source and schema(s) to use as the comparison target. The schemas are compared in the order they appear.

Live without Oracle client:

user/pass@host[:port]/sid{SchemaA} [AS (Normal|SYSDBA|SYSOPER)] (/direct)

Live with Oracle client:

  • TNS name:
(user/pass|/)@tns{SchemaA, SchemaB} [AS (Normal|SYSDBA|SYSOPER)]
  • Manual connection:
(user/pass|/)@host[:port]/service{SchemaA, SchemaB} [AS ...] (/indirect)
  • LDAP
 (user/pass|/)@ldap{SchemaA, SchemaB} [AS ...]

Snapshot:

c:\snapshot.onp{SchemaA}

Scripts folder:

c:\ScriptsFolder{SchemaA}

/verbose

Alias: /v

Verbose mode - displays detailed output.

Contents


Didn't find what you were looking for?