Schema Compare for Oracle - 2.0
Switches used in the command line
/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?
Using Schema Compare for OracleSchema Compare for Oracle
all SQL products
- Compatibility of Red Gate tools in 64-bit environments
- Application has encountered an error and needs to close
- Error message after installing SQL Toolbelt - The description for Event ID ( 1 ) in Source ( nview_info ) cannot be found.
- Changing the temporary directory used by the installer
- Toolbelt Installer "hanging" while "scanning volumes"
- Login failing with "trusted SQL Server connection" error when using RunAs
all products
- Some Red Gate products identified as containing a trojan by Anti-Virus software
- Activation may fail with Unknown Error -1
- Product uses web help although a CHM file is available locally
- Argument exception resulting from missing environment variable
- Check for updates may fail when used through proxies
- 'Unidentified Publisher' error when repairing or uninstalling
- Licensing activates product as standard edition
- Moving Red Gate software products to another machine
- Red Gate tools log locations
- The application UI opening slowly when there is no internet access
Schema Compare for Oracle
all SQL products
all products
- Red Gate product acknowledgements
- Activating your products
- Activating your products
- Red Gate bundle history
- Check for updates
- Troubleshooting Check for Updates errors
- Current versions
- Deactivating your products
- Installing Red Gate products from the .msi file
- Requesting additional activations
- Serial numbers for bundles
- Reactivating using a different serial number
- Extending your trial
- Finding your serial numbers
- Moving a serial number from one computer to another
- No response received for manual activation
- Licensing and activation resources
- Licensing and activation resources
- Troubleshooting licensing and activation errors
- Licensing and activation FAQs
- Red Gate tools log file locations
- Download old versions of products
- Download product prerequisites & utilities
- Support & upgrades
- Upgrading your software
- Upgrading FAQs
