- Developer’s guides to migration
Developer’s guides to migration
The following are a useful set of principals to migration for developers and IT managers:
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.
|Download: DB2 for Linux, UNIX, and Windows|
|Read: DB2 solution Information Center - Database fundamentals, "Installing"|
3. Set SQL compatibility for DB2
Before creating your DB2 database, you need to enable the Oracle Compatibility mode for your DB2 instance.
|Read: SQL Compatibility for DB2 9.7|
|Read: Oracle to DB2 conversion guide: Section 4.2, "Enabling SQL compatibility|
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.
|Read: DB2 solution Information Center - Database fundamentals, "Configuring DB2 database systems|
|Read: Oracle to DB2 conversion guide: Section 4.3, "Creating and configuring the target DB2 database|
5. Use assessment tool for migration preparation
Run the IBM Migration Enablement Evaluation Tool (MEET) to get a quick compatibility assessment of your current Oracle database with DB2. The tool analyses 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.
|Read: Oracle to DB2 conversion guide: Section 3.3, "MEET DB2 evaluation utility|
|Download: IBM MEET DB2 assessment tool|
6. Install and open data migration tool
Get the IBM Data Movement Tool at no charge and install it on your target database server. This tool helps you to easily enable applications from Oracle to run on DB2 as is, with very little or no changes.
|Download: IBM Data Movement Tool|
7. Extract and deploy DDL, table data, and PL/SQL objects for migration
Use the IBM Data Movement Tool to extract compatible DDL, table data, and PL/SQL objects from Oracle and deploy them to DB2.
|Read: IBM Data Movement Tool|
|Read: Oracle to DB2 conversion guide: Section 3.1.1, "Moving DDLs and data with the IBM Data Movement Tool|
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.
|Read: Oracle to DB2 conversion guide: Section 4.5.5, "Resolving incompatibilities with Interactive Deploy"|
|Read: Tips and tricks for solving migration issues due to Oracle features|
9. Verify your migration
Connect to the database in order to verify that the database objects and PL/SQL code were enabled successfully.
|Read: Oracle to DB2 conversion guide: Section 4.6, "Verification of enablement"|
Call Avnet today to speak to an advisor: + 44 (0)113 251 3051