Create DB2 database structure
Once you have the DDL scripts in DB2 syntax, you should create your DB2 UDB 
database and run the DDL scripts to create the database structure.
This part is again supported by tools like MTK. Be sure to check the success of 
the creation of all database objects like tables, keys, and indexes.
2.4.3  Data porting
With the database installed on your new system and the structure of your 
database created, you should migrate the data from the source to the target 
system.
Databases usually provide mechanisms for exporting (dumping) and importing 
(loading) data. We categorized the MySQL data into:
User data: Data about users, access rights, and privileges
Application data: Data that is created and used by an application
Figure 2 4 shows the basic steps of data porting.
MySQL
database
MySQL
user
Export user data
data
(mysqldump)
DB2
script
Convert to
DB2 commands
DB2
Run DB2 script
database
Basic
data
checking
MySQL
Export application data
Import application data
application 
(mysqldump/MTK)
data
(db2load/MTK)
Figure 2 4   Data porting process
 Chapter 2. Planning the migration from MySQL to DB2 UDB 
57






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