*Another Try* Converting Schema to DB2

classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

*Another Try* Converting Schema to DB2

Frank A Nuzzi
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 [hidden email] mailing list.
To unsubscribe: mailto:[hidden email]
For general help: mailto:[hidden email]?subject=help
ObjectWeb mailing lists service home page: http://www.objectweb.org/wws
Reply | Threaded
Open this post in threaded view
|

Re: *Another Try* Converting Schema to DB2

Philippe Legrain
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, [hidden email] <[hidden email]> 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 [hidden email] mailing list.
To unsubscribe: mailto:[hidden email]
For general help: mailto:[hidden email]?subject=help
ObjectWeb mailing lists service home page: http://www.objectweb.org/wws





--
You receive this message as a subscriber of the [hidden email] mailing list.
To unsubscribe: mailto:[hidden email]
For general help: mailto:[hidden email]?subject=help
ObjectWeb mailing lists service home page: http://www.objectweb.org/wws

Main.java (4K) Download Attachment
Reply | Threaded
Open this post in threaded view
|

Re: *Another Try* Converting Schema to DB2

Frank A Nuzzi

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 - [hidden email]



"Philippe Legrain" <[hidden email]>

10/19/2006 07:51 AM

Please respond to
[hidden email]

To
[hidden email]
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, fanuzzi@... < fanuzzi@...> 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
[hidden email] mailing list.
To unsubscribe: mailto:
[hidden email]
For general help: mailto:
sympa@...?subject=help
ObjectWeb mailing lists service home page:
http://www.objectweb.org/wws



--
You receive this message as a subscriber of the [hidden email] mailing list.
To unsubscribe: mailto:[hidden email]
For general help: mailto:[hidden email]?subject=help
ObjectWeb mailing lists service home page: http://www.objectweb.org/wws



--
You receive this message as a subscriber of the [hidden email] mailing list.
To unsubscribe: mailto:[hidden email]
For general help: mailto:[hidden email]?subject=help
ObjectWeb mailing lists service home page: http://www.objectweb.org/wws

Main.java (4K) Download Attachment