I would like to migrate a DB2 database to Oracle without using the Oracle PL SQL Developer migration tool. I would like to use some batch scripts to achieve the same. Is it possible to convert DB2 scripts to Oracle specific scripts by using some commands from command prompt? Any guidance/help for the same would be highly appreciated.
Thanks in advance,
What sort of scripts are you talking about to convert ? Scripts to load data into Oralce or 'create table xxx ...' type scripts ?
And why do you not want to use SQL*Developer as it will do all of that for you ?
Perhaps the following from the SQL Developer documentation is helpful for you: Command-Line Interface for Migration As an alternative to using the SQL Developer graphical interface for migration operations, you can use the migration batch file (Windows) or shell script (Linux) on the operating system command line. These files are located in the sqldeveloper\sqldeveloper\bin folder or sqldeveloper/sqldeveloper/bin directory under the location where you installed SQL Developer. migration.bat or migration.sh accepts these commands: capture, convert, datamove, delcaptured, delconn, delconverted, driver, generate, guide, help, idmap, info, init, lscaptured, lsconn, lsconverted, mkconn, qm, runsql, and scan. For information about the syntax and options, start by running migration without any parameters at the system command prompt. For example: C:\Program Files\sqldeveloper\sqldeveloper\bin>migration You can use the -help option for information about one or more actions. For the most detailed information, including some examples, use the -help=guide option. For example: C:\Program Files\sqldeveloper\sqldeveloper\bin>migration -help=guide