Migrating from a non-Db2 relational database management system is a more complex process than migrating from a Db2 database product. Therefore, you must carefully determine what the migration process entails and create a porting plan.
The porting plan must include tasks such as, converting your database objects to create the equivalent database objects in a Db2 database, moving the actual data to the new Db2 database and porting your database applications. Porting your applications refers to converting SQL statements, modifying interface calls, and converting any database-specific code to access Db2 databases.
The most common approaches to converting database application code are manual conversion, dynamic call translation, and automated conversion. In general, conversion tools take source code as input and translate data management calls to equivalent SQL calls. Information from the source and target database, and the program code, is used to build the new SQL statements.
The IBM® Database Conversion Workbench (DCW) integrates many of the tools that are used for database conversions into a single integrated development environment. Whether converting to Db2 database from another relational database management system (RDBMS), or moving from one version of Db2 database to another version, DCW provides an easy to use framework to take you through the conversion process. DCW is available as a complementary download from the IBM Database Conversion Workbench web page.
The most important and frequently accessed resources that IBM offers to help all aspects of migration from a non-Db2 relational database management systems are as follows: