*Another Try* Converting Schema to DB2
All, Since the Mailing list seems to be getting alot of replies lately I wanted to give this question another shot. 1. Has anyone successfully converted the existing XWiki MySQL schema to be used with DB2? 2. Has anyone successfully ran XWiki in the IBM WebSphere enviroment? My past experience is that XWiki would not even start in WAS 6.1. Thanks, Tony Nuzzi
Hi Tony, Here we do run xwiki on top of DB2 + JBoss. I can't help with websphere, but can explain how we did to use db2. What we did basically is to install the xwiki db schema on Mysql, then used a tool for migrating from the mysql db to the DB2 schema. 2 steps: 1. We converted the DB schema (NOT the data, that does not work) from mysql to db2 using IBM's mysql to db2 migration toolkit ( http://www-306.ibm.com/software/data/db2/migration/, then MySQL to DB2 UDB for Linux, you need to register to obtain the tool but it's free). This allowed us to have the Tables definitions set to the DB2 syntax. Then you need to use your favorite tool to create the tables in your target DB2 schema. 2. With That small (and dirty) Java program that simply reads table from the Mysql source and writes it on the db2 data source...(source attached). You need to include JDBC drivers for mysql and DB2 into your classpath in order to run that program. Quick and dirty, I told you... but it works. note that this second step DOES NOT creates the tables, it is done in point 1. Enjoy Philippe Legrain On 10/18/06, [email protected] <[email protected]> wrote:
All, Since the Mailing list seems to be getting alot of replies lately I wanted to give this question another shot.
1. Has anyone successfully converted the existing XWiki MySQL schema to be used with DB2?
2. Has anyone successfully ran XWiki in the IBM WebSphere enviroment? My past experience is that XWiki would not even start in WAS 6.1.
Thanks,
Tony Nuzzi
-- You receive this message as a subscriber of the [email protected] list. To unsubscribe: mailto:[email protected] For general help: mailto:[email protected]?subject=help ObjectWeb mailing lists service home page: http://www.objectweb.org/wws
Philippe, The problem I am running into is converting the MySQL schema to DB2. Do you have the DDL that you guys are using? If so, can you send that to me? Thanks, Frank (Tony) Nuzzi AIS - Install Solution Developer Phone 838-3781, t/l 678-3781 External E-mail - [email protected] "Philippe Legrain" <[email protected]> 10/19/2006 07:51 AM Please respond to [email protected] To [email protected] cc Subject Re: [xwiki-dev] *Another Try* Converting Schema to DB2 Hi Tony, Here we do run xwiki on top of DB2 + JBoss. I can't help with websphere, but can explain how we did to use db2. What we did basically is to install the xwiki db schema on Mysql, then used a tool for migrating from the mysql db to the DB2 schema. 2 steps: 1. We converted the DB schema (NOT the data, that does not work) from mysql to db2 using IBM's mysql to db2 migration toolkit ( http://www-306.ibm.com/software/data/db2/migration/ , then MySQL to DB2 UDB for Linux, you need to register to obtain the tool but it's free). This allowed us to have the Tables definitions set to the DB2 syntax. Then you need to use your favorite tool to create the tables in your target DB2 schema. 2. With That small (and dirty) Java program that simply reads table from the Mysql source and writes it on the db2 data source...(source attached). You need to include JDBC drivers for mysql and DB2 into your classpath in order to run that program. Quick and dirty, I told you... but it works. note that this second step DOES NOT creates the tables, it is done in point 1. Enjoy Philippe Legrain On 10/18/06, [email protected] < [email protected]> wrote: All, Since the Mailing list seems to be getting alot of replies lately I wanted to give this question another shot. 1. Has anyone successfully converted the existing XWiki MySQL schema to be used with DB2? 2. Has anyone successfully ran XWiki in the IBM WebSphere enviroment? My past experience is that XWiki would not even start in WAS 6.1. Thanks, Tony Nuzzi -- You receive this message as a subscriber of the [email protected] mailing list. To unsubscribe: mailto: [email protected] For general help: mailto:[email protected]?subject=help ObjectWeb mailing lists service home page: http://www.objectweb.org/wws -- You receive this message as a subscriber of the [email protected] mailing list. To unsubscribe: mailto:[email protected] For general help: mailto:[email protected]?subject=help ObjectWeb mailing lists service home page: http://www.objectweb.org/wws
participants (3)
-
fanuzzi＠us.ibm.com -
Frank A Nuzzi
-
Philippe Legrain