This discussion is archived
3 Replies Latest reply: Nov 9, 2012 7:37 AM by wkobargs RSS

Migration from DB2 to Oracle without using Oracle SQL Developer

972512 Newbie
Currently Being Moderated
Hi,
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,
Moorthy
  • 1. Re: Migration from DB2 to Oracle without using Oracle SQL Developer
    appsdba_new Newbie
    Currently Being Moderated
    Hi Moorthy,

    Manual migration from DB2 to Oracle is tough ask.

    Please refer the link below to load data into Oracle from DB2 using SQL Loader,

    http://www.dba-oracle.com/tips_sqlldr_loader.htm

    Thanks.
  • 2. Re: Migration from DB2 to Oracle without using Oracle SQL Developer
    mkirtley-Oracle Expert
    Currently Being Moderated
    Hi,
    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 ?

    Regards,
    Mike
  • 3. Re: Migration from DB2 to Oracle without using Oracle SQL Developer
    wkobargs Journeyer
    Currently Being Moderated
    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

    Regards
    Wolfgang

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points