Home > SQL Developer Concepts and ... > Command-Line Interface for ...
For certain operations, you can invoke SQL Developer from the command line as an alternative to the graphical user interface. To use the command-line interface, go to the sqldeveloper\sqldeveloper\bin
folder or sqldeveloper/sqldeveloper/bin
directory under the location where you installed SQL Developer, and enter sdcli
.
For example, if you installed SQL Developer on Windows under C:\, enter the following commands:
C:\>cd c:\sqldeveloper\sqldeveloper\bin
C:\sqldeveloper\sqldeveloper\bin>sdcli
Available features:
cart: Database Cart Batch Tasks
dba: Basic Batch DBA Tasks
format: SQL Format Task
migration: Database Migration Tasks
reports: Basic Batch Reporting Tasks
unittest: Unit Testing Batch Tasks
If you enter just sdcli
, the list of available features shows each sdcli command and its associated feature. To get brief information about commands for a specific feature, enter sdcli
<feature-name>
. For example:
C:\sqldeveloper\sqldeveloper\bin>sdcli migration
HELP:
Syntax:
Migration -help|-h=<actions> to get help on one or more actions.
where
<actions> could be one or more (comma separated list) actions or guide
guide provides a walk through of a typical migration
Examples:
Migration -help=capture
Migration -h=capture,convert
Migration -h=guide
Valid actions:
capture, convert, datamove, delcaptured, delconn, delconverted, driver, generate
, guide, idmap, info, init, lscaptured, lsconn, lsconverted, mkconn, qm, runsql,
scan and translate
If a command has a -logfile
option, the generated log file is empty if the command failed; otherwise, it contains one or more descriptive messages about the operation.
Related Topics
Command-Line Interface for SQL Formatting