Additional /schemaexport and /schemaimport Arguments

Last modified: March 28, 2025

This topic gives detailed description of command line switches and examples of their usage.

/schemaexport Arguments

To get more information on switches related to schema export in the command line interface, type:

C:\Program Files\Devart\Compare Bundle for Oracle\dbForge Schema Compare for Oracle>schemacompare.com /schemaexport /?

Below all switches of this option are described, together with usage examples.

Argument	Action and Usage
`/connection`	The switch is used to specify a connection string with additional parameters. The command usage is as follows: `/connection:<connection_string>` An example of using the /connection argument: `/connection:"User Id=some_user_id;Password=password;Server=ORCL;Unicode=True;Pooling=False"`
`/outputfile`	Use this switch to specify a file name for storing the schema. This switch overrides the file name specified in the schema export project. The command usage is as follows: `/outputfile:<file_name>` An example of using the /outputfile argument: `/outputfile:"D:\sample.sql"`
`/password`	Use this switch to specify a server password. This switch overrides the password specified in the schema export project or in the connection string. The command usage is as follows: `/password:<pw>` An example of using the /password argument: `/password:"1wert45"`
`/projectfile`	Use this switch to specify the required schema export project. Some project option can be overridden by switches. The command usage is as follows: `/projectfile:<file_name>` An example of using the /projectfile argument: `/projectfile:"D:\sample.backup"`
`/schema`	Use this switch to specify a schema to be exported. The switch overrides the schema specified in the schema export project or in the connection string. The command usage is as follows: `/schema:<schema_name>` An example of using the /schema argument: `/schema:"scott"`

Below is the example of the /shcemaexport arguments usage:

C:\Program Files\Devart\Compare Bundle for Oracle\dbForge Schema Compare for Oracle>schemacompare.com /schemaexport /connection:"User Id=yourusername;Server=ORCL1020" /outputfile:"D:\sample.sql" /password:"yourpassword" /projectfile:"D:\sample.backup" /schema:SCOTT /encoding:"UTF-8" 

/schemaimport Arguments

To get more information on switches related to schema import in the command line interface, type:

C:\Program Files\Devart\Compare Bundle for Oracle\dbForge Schema Compare for Oracle>schemacompare.com /schemaimport /?

Below all switches of this option are described, together with usage examples.

Argument	Action and Usage
`/connection`	The switch is used to specify a connection string with additional parameters. The command usage is as follows: `/connection:<connection_string>` An example of using the /connection argument: `/connection:"User Id=some_user_id;Password=password;Server=ORCL;Unicode=True;Pooling=False"`
`/encoding`	Use this switch to specify the necessary encoding for opening and executing the script. The command usage is as follows: `/encoding:<codepage\|encoding name>` An example of using the /encoding argument: `/projectfile:"UTF-8"`
`/inputfile`	Use this switch to specify an SQL or ZIP file with the schema script. The command usage is as follows: `/inputfile:<file_name>` An example of using the /inputfile argument: `/inputfile:"D:sample.zip"`
`/password`	Use this switch to specify a server password. This switch overrides the password specified in the connection string. The command usage is as follows: `/password:<pw>` An example of using the /password argument: `/password:"1wert45"`
`/schema`	Use this switch to specify a schema to be imported. The switch overrides the schema specified in the connection string. The ALTER SESSION SET CURRENT_SCHEMA statements will be ignored. It doesn’t affect objects with fully qualified names. The command usage is as follows: `/schema:<schema_name_>` An example of using the /schema argument: `/schema:"scott"`

Below is the example of the /shcemaimport arguments usage:

C:\Program Files\Devart\dbForge Schema Compare for Oracle>schemacompare.com /schemaimport /connection:"User Id=yourusername;Server=ORCL1020" /password:"yourpassword" /schema:SCOTT /inputfile:"D:\HR.sql" /encoding:"UTF-8" 

Was this page helpful?