This topic gives detailed description of command line switches and examples of their usage.
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"
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"