/abortonwarnings:<warning level>

Alias: /aow

Aborts the deployment if there are any deployment warnings at or above the warning level specified. You can specify medium or high.  This will exit with code 63.

/activateserial:<serial number>

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 Deployment Suite for Oracle license.

/behavior:<value>

Alias: /b

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

The defaults are /b:hdrg (scriptheader, defineoff, detectcolumnrenames, and crossschemapermissions)

/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.

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

/deployallobjects

Alias: /dao

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

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

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

/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.

/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>

Alias: /i

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

The defaults are /i:sdwqgva (slowdependencies, dependentobjects, whitespace, doublequotes, storage, sequencevalue, and mviewvalue)

/ignorerules:<IgnoreRulesFile.scpf>

Alias: /igr

Excludes/includes objects (per object-type) from comparison based on the Ignore Rules file: Using ignore rules

/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.

/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

sco ... /loglevel:verbose

/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

/reportselectedobjects

Alias: /rso

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

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

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>

Alias: /sfo

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

/snapshot:<snapshot file name>

Alias: /snp

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

/snapshot1:<snapshot file name>

Alias: /snp1

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.onp"

/snapshot2:<snapshot file name>

Alias: /snp2

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.onp"

/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)

• Manual connection with /forceservicename:

user/pass@host[:port]/service{SchemaA, SchemaB} [AS (Normal|SYSDBA|SYSOPER)] /forceservicename

• 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.

/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.