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






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