See if the "sdcli" command migration feature meets your requirement
sdcli migration -help|-h=<actions> to get help on one or more actions.
<actions> could be one or more (comma separated list) actions or guide
guide provides a walk through of a typical migration
sdcli migration -help=capture
sdcli migration -h=capture,convert
sdcli migration -h=guide
capture, convert, datamove, delcaptured, delconn, delconverted, driver, generate, guide, idmap, info, init, lscaptured, lsconn, lsconverted, mkconn, qm, runsql, scan and translate
So it does exist a command line interface to interact with SQL Developer? Interesting, why is it not offically supported? I found some entries on that Jeff Smith blog, but no real tutorials nor any kind of doc. Anyway, I started playing with it and seems a rather limited command interpreter, maybe that's why there is so scarce available info online about it? Gotta figure out how it works, maybe I can use it for what I need. Thanks a lot, Glen!
This pre-dates by many years my SQL Developer experience, but it seems ...
1) A command line interface for migrations first appeared in the 3.x releases (as sqldeveloper\bin\migration.bat)
2) Along with an earlier command line interface for schema exports and imports in 2.x (as sqldeveloper\bin\ututil.bat)
3) These two features (plus others) got merged under sdcli.exe in 4.0
Not sure if the documentation changed much since 3.x, but here is the official migrations doc (see section 2.4) -
I believe any focus SQL Developer had on a command line interface shifted to sqlcl as of 4.x. Maybe someday those sdcli features will move over into sqlcl? Only the product manager ( thatJeffSmith-Oracle ) may know what's in store for us.
a single, merged CLI is on its way, yes
You guys are amazing! Thank you very much for all your support. In fact now I realize how ignorant I was, I didn't even take a look at SQLcl believing it was a plugin interface to be called via SQL Developer, like a interactive command line running inside its main window. Now I see that it is in fact a standalone application that runs independently of SQL Developer. It's just a shame it doesn't migrate third party databases yet. Hey Mr. Jeff, will the merged version be available anytime soon? Anyway, I'm hitting some errors with sdcli migration and its doc is not really helpful; it mainly states that detailed information is available with the -help option. The migration wizard works just fine, but I cannot reproduce it with the command line. Does it worth creating a new thread to ask for help? Thank you all once more for the help and tips.
What are you trying exactly that's not working and what is the error message you're getting?
I will start a new thread, got to much to explain and show here. Also, this question was already answered, a new one might be more useful to others.