Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

DB2 to Oracle Migration

494136Mar 3 2010 — edited Oct 17 2010
Can someone from sql dev help us in migrating a database from db/2 to Oracle

Migrate IBM DB2 v9.5,9.7 database to Oracle 11gR2
Oracle Version: 11g R2
Oracle SQL Developer Version: 2.1.0.63 Build MAIN-63.73


Procedure we're trying to implement following SQL Developer Guide and IBM DB2 Migration Supplement
1. Using Oracle SQL Developer, We go to Tools->Migration->Third Party Database Offline Capture->Create Database Capture Scripts.
Results: 4 files (db2v9.ocp, getForeignKeys.sh, getProcedures.sh, startDump.sh)
2. Copy the files to DB2 server and run startDump.sh on database with user and password.
Results:
./startDump.sh DS2 db2inst1 password
Clearing older data files
Connecting to DS2 as db2inst1

Database Connection Information

Database server = DB2/LINUXX8664 9.5.0
SQL authorization ID = DB2INST1
Local database alias = DS2

Output Files: connect.dat, schemas.dat, 1 Folder - (checkContraints.dat, foreignKeys.dat, indexes.dat, primarykeys.dat, routines.dat, synonyms.dat,tables.dat, triggers.dat, views.dat)

Contents of db2v9.ocp:
OfflinePluginIdentifier=oracle.dbtools.migration.workbench.plugin.db2v9.DB2v9Plugin

3. At this point we're instructed to run some data export scripts that have not been created, and we cannot locate (i.e. - unload_script.sh). When we try to generate Data Move Scripts in SQL Developer (Tools->Migration->Script Generation->Generate Move Scripts), it will not allow me because there is no Converted Model.

At this point, None of the scripts described in the documentation exist. We cannot proceed with anything in SQL Developer. If we manually run db2 export commands for data, and manually re-create the tables, indexes, and stored procedures in Oracle and build my own control files for the SQL*Loader, we can import the data into Oracle successfully.

Is there any way to trace why scripts have not been created? DO we have any trace options in SQL Developer?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 14 2010
Added on Mar 3 2010
3 comments
3,390 views