Moving from an Oracle database to a DB2 database, detailed steps

Oracle to DB2 Migration Tool

　　1. IBM DB2 Migration Toolkit

Simplify and improve migration to DB2 UDB using the free IBM DB2 Universal Database (UDB) Migration Toolkit (MTK). This new migration utility provides wizards and Easy-to-use five-step interfaces that help you quickly convert existing Sybase, Microsoft SQL Server, and Oracle database objects to the DB2 common database. Using MTK, you can automatically convert data types, tables, columns, views, indexes, stored procedures, and triggers into equivalent DB2 database objects. MTK provides database administrators (DBAs) and application programmers with the tools they need to automate migration tasks, which have been inefficient and costly in the past. By using the following features in MTK, you can reduce downtime, eliminate human error, and reduce other resource consumption associated with manual and traditional database migrations. MTK can run on AIX, Linux, Solaris, and Windows operating systems.

With this tool, I tried many times, and in the final step, I could not succeed.

　2. IBM Data Movement Tool (recommended use, simple, convenient, tools only 1M)

Quickly convert existing Oracle database objects to DB2 common database using the DB2 compatibility feature and the Free Data Migration tool, available from IBM, to Movement Tool. At the same time, it transforms the database access language and interface used in the application, and finally realizes the complete migration of the whole application system.

I'll explain the steps to use this tool in detail below.

　3. IBM Optim Development Studio

IBM Optim Development Studio, which provides an integrated database development environment for Oracle, DB2, and Informix. Optim Development Studio has increased productivity by 50% in developing and testing SQL and XQuery queries, stored procedures, Web services, and Java data-access tiers, and allows data-package, stored procedures, tables, user-defined in different or identical data servers Copy and paste of semantic functions, user-defined types, views, patterns, and so on.

These three tools are from the official IBM, you need to go to the official download.

Two: IBM Data Movement Tool steps to use

1. Click Ibmdatamovementtool.cmd to enter the main interface

After entering, note:

A. Oracle on the left, enter the database name, port, ID, password

B.JDBC Driiver: If you don't have a local online download

C. After filling, click Connect to ORACLE, if the input is correct, the connection will show the success of the prompt

D. The right side is DB2, fill it with the left.

2. After successful connection

3. Then return to the main page:

A. First select the database to export

B. Second Click Extract Ddl/data (this may take a while, during which the view file interface displays the process, such as the second figure below)

C. After successful export, click Deploy Ddl/data (this may take a while, during which the view file interface displays the procedure, such as the second figure below)

4. At this point, the data migration should be successful.

problems encountered during its migration:

Problem: Before the completion of the DB2, only the table organization, index, etc. (in short, except for no data, all the others have).

Workaround: Migrate on the DB2 server native, or install DB2 database locally

If you have any further questions, please check IBM website: http://www.ibm.com/developerworks/cn/data/library/techarticle/dm-0906datamovement/