Schema Compare for Oracle - 3.0

Schema Compare for Oracle

Switches used in the command line - Schema Compare for Oracle

/project:<project file>

Alias: /pr

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

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

/report:<filename>

Alias: /r

Generates a report and writes it to the specified file. You can use the /includeidentical and /reportselectedobjects 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

Note that if there is already a file of the same name in the location you specify, it will be overwritten.

/reporttype:<report type>

Alias: /rt

Defines the file format of the report produced by the /report switch. The default setting 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

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

/reportselectedobjects

Alias: /rso

Specifies that only objects selected in the project file will be included in the report. For example:

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

/scriptfile:<script filename>

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:\Schema Compare for Oracle\Scripts\WidgetDeployment.sql"

/snapshot1:<snapshot filename>

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

Note that if there is already a file of the same name in the location it will be overwritten

/snapshot2:<snapshot filename>

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

Note that if there is already a file of the same name in the location it will be overwritten

/deploy

Alias: /dep

Deploys the schema changes in a project after comparison. For example:

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. For example:

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

/deployscriptencoding:<encoding>

Alias: /depenc

Specifies the character encoding used when writing the SQL deployment script. The default setting is UTF8.

Arguments

UTF8

UTF-8 encoding, without preamble

UTF8WithPreamble

UTF-8 encoding, with 3-byte preamble

Unicode

UTF-16 encoding

ASCII

ASCII encoding

For eaxmple, to create a deployment script using ASCII encoding:

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

/scriptfile:"C:\Schema Compare for Oracle\Scripts\WidgetDeployment.sql"

/deployscriptencoding:ASCII

Was this article helpful?

Search support
Forums
Visit the Schema Compare for Oracle forum.
Learning Schema Compare for Oracle
Knowledge base

Schema Compare for Oracle

all SQL products

all products

Notes & articles

Schema Compare for Oracle

all SQL products

all products

Demos & walkthroughs

Schema Compare for Oracle