Skip to main content

By clicking Submit, you agree to the developerWorks terms of use.

The first time you sign into developerWorks, a profile is created for you. Select information in your profile (name, country/region, and company) is displayed to the public and will accompany any content you post. You may update your IBM account at any time.

All information submitted is secure.

  • Close [x]

The first time you sign in to developerWorks, a profile is created for you, so you need to choose a display name. Your display name accompanies the content you post on developerworks.

Please choose a display name between 3-31 characters. Your display name must be unique in the developerWorks community and should not be your email address for privacy reasons.

By clicking Submit, you agree to the developerWorks terms of use.

All information submitted is secure.

  • Close [x]

developerWorks Community:

  • Close [x]

DB2 fundamentals for Oracle professionals: Migrating from Oracle to DB2

Date:  07 Oct 2011 (Published 22 Mar 2011) |Level: Intermediate |

1. Learn about DB2 compatibility with Oracle

Get an overview of the DB2 compatibility features that make it possible to move Oracle-based applications to DB2, virtually unchanged.

2. Install DB2 for migration

If you don't already have DB2, you can easily download and install our 90-day trial version of DB2 for Linux, UNIX, and Windows.

3. Set SQL compatibility for DB2

Before creating your DB2 database, you need to enable the Oracle Compatibility mode for your DB2 instance.

4. Create and configure target DB2 database

Explore the DB2 environment, learn how to create a database, and become familiar with the DB2 configuration tools and settings.

5. Use assessment tool for migration preparation

Use the IBM Database Conversion Workbench (DCW) to assess the compatibility of your current Oracle database with DB2. The tool analyzes all the objects in your Oracle database and scores them, then produces a report of what will work out of the box and where you will need to make adjustments.

6. Install and open data migration tool

Install the IBM Database Conversion Workbench on your target database server. DCW integrates many of the tools used for database migration into an easy to use plug-in for IBM Data Studio.

7. Extract and deploy DDL, table data, and PL/SQL objects for migration

Use the IBM Database Conversion Workbench to extract DDL, table data, and PL/SQL objects from an Oracle database, convert incompatible code, and finally deploy the objects and data to DB2.

8. Review and resolve migration of DDL, table data, and PL/SQL objects

Check to make sure everything you migrated is working, and get hints and tips on how to re-solve issues that may arise.

9. Verify your migration

Connect to the database in order to verify that the database objects and PL/SQL code were enabled successfully.




Rate this content




Give us feedback

Submission failed. Please try again.

Please complete one of the following questions before submitting.

1. Are you finished with this knowledge path?

       

2. How much did you learn?

           

3. Tell us more

  • What did you like/dislike?
  • What can we do better?

2500 characters left

Disabled Submit button

developerWorks: Sign in


Need an IBM ID?
Forgot your IBM ID?


Forgot your password?
Change your password

By clicking Submit, you agree to the developerWorks terms of use.

 


The first time you sign into developerWorks, a profile is created for you. Select information in your developerWorks profile is displayed to the public, but you may edit the information at any time. Your first name, last name (unless you choose to hide them), and display name will accompany the content that you post.

Choose your display name

The first time you sign in to developerWorks, a profile is created for you, so you need to choose a display name. Your display name accompanies the content you post on developerWorks.

Please choose a display name between 3-31 characters. Your display name must be unique in the developerWorks community and should not be your email address for privacy reasons.

(Must be between 3 – 31 characters.)


By clicking Submit, you agree to the developerWorks terms of use.

 


Thank you for your feedback. We appreciate your sharing your opinion with us.

Do you want to save your progress?

, Sign in to save your progress

Save your progress

Sorry. Our server is not available, and we cannot display your saved progress at this time.

Your progress will be displayed when the server is available again. Any previous progress is retained, and additional progress is being tracked.

If your most recent progress is not displayed within 24 hours, you can click the checkmark to indicate completion.

static.content.url=http://www.ibm.com/developerworks/js/artrating/
SITE_ID=1
Zone=Information Management
ArticleID=756185
publish-date=10072011