/abortonwarnings:<warning level>

Alias: /aow

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

/activateserial:<serial number>

Attempts to activate Data Compare for Oracle.

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

dco /activateSerial:123-456-789012-ABCD

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

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

/behavior:<value>

Alias: /b

Specifies options that affect deployment behavior.

The default is scriptheader.

/comparison:<value>

Alias: /c

Specifies options that affect comparison.

The defaults are ignorewhitespace and ignorecontrolcharacters.

/comparisonkeys:<regular expression>:<index name or comma-separated columns>

Alias: /ck

Specifies which index or column(s) to use as the comparison key for specific tables or views (case-insensitive). If a column and an index have the same name, the index will be used.

For example, to use PK_WidgetPrices as the comparison key in the table WidgetPrices:

dco ... /comparisonkeys:"WidgetPrices":PK_WidgetPrices
dco ... /comparisonkeys:"WidgetPrices":WidgetID,Active

Attempts to deactivate Data Compare for Oracle. An internet connection is required to deactivate the product.

/deploy

Alias: /d

Deploys the schemas after comparison. Changes are migrated from <schema1> to <schema2>.

/deployscriptencoding:<encoding>

Alias: /depenc

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

Arguments

dco /project:"C:\Data Compare for Oracle\Projects\WidgetDatabases.dco"
/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.

/exclude:<regular expression>

Specifies objects to exclude (case-insensitive).

Use /exclude for each object you want to exclude. Alternatively, use /exclude only once, and specify table or view names using regular expressions. Use double quotes (") for an exact match.

For example, to include the table Contacts:

dco ... /exclude:"Contacts"

/excludecolumns:<regular expression>:<comma-separated column names>

Alias: /ec

Specifies columns to exclude for specific tables or views. Specify table or view names using regular expressions.

For example, to exclude the column WidgetName in the table WidgetReferences:

dco ... /excludecolumns:"WidgetReferences":WidgetName

More information on how to specify table and view names using regular expressions

/help

Alias: /?

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

/include:<regular expression>

Specifies objects to include (case-insensitive).

Use /include for each object you want to include. Alternatively, use /include only once, and specify table or view names using regular expressions. Use double quotes (") for an exact match.

If you specify /include, all other tables and views are excluded by default. For example, to include only the table Products:

dco ... /include:"Products"

More information on how to specify table and view names using regular expressions

/includecolumns:<regular expression>:<comma-separated column names>

 Alias: /ic

Specifies columns to include for specific tables or views. Specify table or view names using regular expressions.

 If you specify /includecolumns, all other columns are excluded by default.

For example, to include only the columns ID, Price, and Date in the table WidgetPrices:

dco ... /includecolumns:"WidgetPrices":ID,Price,Date

More information on how to specify table and view names using regular expressions

/includerows:<value>

Alias: /ir

Specifies types of rows to include in reports, scripts, or deployments. Specify multiple values as a comma-separated list. The defaults are source, target, and different.

dco ... /includerows:source,different

/indirect

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

/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

dco ... /loglevel:verbose

/onlyfirst1000rows

Alias: /1000

Shows only the first 1000 rows in the report.

/overwritereports

Alias: /f

Forces the overwriting of any report files that already exist. If this switch isn't used and a file of the same name already exists, the program will exit with the exit code indicating an IO error.

/project:<project file>

Alias: /p

Specifies a saved Data Compare for Oracle project file (.dco) to compare.

dco /project:"C:\Data Compare for Oracle\Projects\WidgetDatabases.dco"

/quiet

Alias: /q

Quiet mode - displays no output.

/report:<file name or directory>

Alias: /r

Exports results as .csv files to the specified directory, or as an HTML report to the specified file name. If the /reporttype is CSV, this specifies a directory to export the .csv files to. If the /reporttype is HTML, this specifies a file name to write the HTML report to.

To overwrite an existing report file, use /overwritereports. If you try to export a report file with the same name as an existing report file without using /overwritereports, the program will exit with the exit code indicating an IO error.

/reportrows:<reportrows1>:<reportrows2>:...<reportrowsN>

This switch is deprecated. Instead use /includerows.

/reporttype:<report type>

Alias: /rt

Values: CSV (default), HTML

Specifies the type of report produced by the /report switch.

/scriptfile:<file name>

Alias: /sf

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

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

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

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

/verbose

Alias: /v

Verbose mode - displays detailed output.