The IBM Rational Rose Data Modeler Edition is a data design tool which 

integrates application design with database design and maps data model with 

object model. It allows database designers, business analysts and developers 

to work together through a common language. Use this tool for migration 

requires your MySQL model file to be available to converting to DB2 UDB 

physical model.

CA AllFusion ERwin Data Modeler

ERWin is database modelling tool which support easy creation and 

maintenance of relational databases. It helps you create entity relationship 

diagram from MySQL database, which can be converted to DB2 database 

structure. It can automatically generates tables, key elements, and database 

design.

Embarcadero Technologies ER/Studio

ER/Studio is a model driven application for the logical and physical analysis, 

design, creation, and maintenance of database objects. It can 

reverse engineer the complete schema from MySQL database. 

Database structure conversion process using modeling tools

Database structure conversion using the modeling tool is a very neat technique 

for database conversion as lot of applications already have entity relation 

diagram. The conversion can be done very easily by following the steps given 

below:

Reverse engineer database objects using a DDL script or an existing 

database using one of the modeling tool.

Switch to a physical model.

Select DB2 database as a target database and generate a DDL script for a 

new target. 

Create DB2 database structure using DDL scripts.

Limitation of this technique is that not everyone can afford costly modeling tools 

just for migration.

5.5  Sample database migration

This section demonstrate the database structure conversion for our sample 

BHMS Application from MySQL to DB2 UDB. BHMS is small real world Web 

application consisting of tables, views and indexes. Before starting the database 

conversion, please see the existing database structure in 3.1.2,  Database 

structure  on page 71.

 Chapter 5. Database porting 

117