IBM DB2 Migration Toolkit (MTK)
MTK helps you to migrate from relational database systems like MySQL, Oracle 
and Microsoft SQL Server to DB2 UDB.
The tool can be used to generate 
Data Definition Language (DDL) 
scripts to 
create a database, tables, indexes and primary keys in DB2 UDB based on an 
existing MySQL database.
It also supports you retrieving data out of a MySQL database and importing the 
data into the created DB2 UDB database.
In our sample project we used MTK on the following steps:
Extract DDL from our MySQL sample database
Convert DDL to DB2 UDB syntax
Create the DB2 database
Create the DB2 database structure
Export MySQL data
Import data into DB2 UDB
If you want to download MTK or get more information about it, please refer to:
http://www.ibm.com/software/data/db2/migration/mtk/
Other available migration tools
Some other tools can be found on the Internet including the following (among 
others). These tools and services are not provided by IBM, nor does IBM make 
guarantees about the usage of these tools:
SQLPorter
A commercial software by RealSoftStudio Inc. for Windows operating system. 
For further details see 
http://www.realsoftstudio.com
SQLWays
A commercial tool by Ispirer Systems for Windows operating system. For 
more details see 
http://www.inspirer.com
2.4  The migration process
For accurate planning it is important to understand the steps to complete the 
migration project. To estimate the project effort correctly and migrate the 
database and application successfully, each of the steps should be planned. 
Figure 2 2 shows the basic migration process steps.
54 
MySQL to DB2 UDB Conversion Guide






footer




 

 

 

 

 Home | About Us | Network | Services | Support | FAQ | Control Panel | Order Online | Sitemap | Contact

san diego web hosting

 

Our partners: PHP: Hypertext Preprocessor Cheap Web Hosting JSP Web Hosting Ontario Web Hosting  Jsp Web Hosting

Cheapest Web Hosting Java Hosting Cheapest Hosting

Visionwebhosting.net Business web hosting division of Vision Web Hosting Inc.. All rights reserved