Command-Line Interface for SQL Developer

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

Command-Line Interface for Migration

Command-Line Interface for Unit Testing