Porting 
preparation
and 
installation
Database
structure
porting
Data
porting
Application
porting
Basic
administration
Testing
and
tuning
Figure 2 2   Steps of the migration process
2.4.1  Porting preparation and installation
After deciding which target system you want to use, you can set up the following: 
Install the hardware, the operating system with users and access rights, the 
network connections, any used software, and finally the DB2 UDB version of 
your choice.
2.4.2  Database structure porting
Once the DB2 UDB is installed in the target, you can port the database structure 
from the source MySQL database to DB2 UDB.
The database structure is usually described by 
Database Definition Language 
(DDL) 
statements. DDL scripts include the creation of tables, keys, and indexes. 
Since the DDL syntax for MySQL and DB2 UDB is different, a converting process 
is required. Using a tool to port database structure can save time and effort. 
Figure 2 3 shows the database structure porting the basic steps.
 Chapter 2. Planning the migration from MySQL to DB2 UDB 
55






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