3 Replies Latest reply: Nov 9, 2012 9:37 AM by wkobargs-Oracle RSS

    Migration from DB2 to Oracle without using Oracle SQL Developer

    972512
      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
          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
            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-Oracle
              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