Jon, It seems you are still in the planning stage. First, if you have good documentation on the DB2 (i.e. ER Diagrams, schema etc.) become familiar with those for the purpose of maintaining the logic as you develop towards your MySQL sink. Know how applications that run against the DB2 database utilize it such as transactions or simply static data storage. Some of the firms I have worked with that were DB2 shops (MVS to OS/2) usually had libraries of utilities written in REXX for running jobs or everyday upkeep. If those are available to you, they might give you some ideas in your effort to migrate the tables and eventually the data.
My experience with writing utilities in Java has been good. I found that writing a program for installing an application also required a utility to create the tables. Then another quick and dirty utility to insert all the static data (AMA CPT Codes) the application would use. I wrote that in Java so that the data could be retrieved from my web server and installed to workstations or laptop systems. I tested the Java program on DB2 tables and I am still in the process of testing them on MySQL and dumping the data from the tables to check for consistency or errors. As you are aware, if you change the logical or physical nature of the database even minor changes in the process of migration, work seems to grow exponentially on the application side. If you consider the DB2 -> XML with Java programming and then some PHP, PERL, C++, look to reduce redundancy in your effort and plan to spend time testing to make sure you reach your goal of maintaining the table logic and data from source to sink. Regard, John Wubbel On 7 Nov 2001, at 18:16, Jon Shoberg wrote: > > Anyone know of method or resources for taking tables from a DB2 database > and migrating them to mySQL tables? My preferred path would be from DB2 to > XML docs via java programming and then mySQL migration by some API (PHP, > PERL, C++). I'm writing my own programs here. What I am interested in are > the steps to maintaining the table logic and data from source to sink. I'm > usnig mySQL on the other end for remote web work. > > any thoughts ? > > jon > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php