[xwiki-dev] *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 - fanuzzi at us.ibm.com



"Philippe Legrain" <legrain at gmail.com> 
10/19/2006 07:51 AM
Please respond to
xwiki-dev at objectweb.org


To
xwiki-dev at objectweb.org
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 at us.ibm.com < fanuzzi at us.ibm.com> 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 xwiki-dev at objectweb.org 
mailing list.
To unsubscribe: mailto: xwiki-dev-unsubscribe at objectweb.org
For general help: mailto:sympa at objectweb.org?subject=help
ObjectWeb mailing lists service home page: http://www.objectweb.org/wws



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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.xwiki.org/pipermail/devs/attachments/20061019/ad240c3f/attachment.html 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Main.java
Type: application/octet-stream
Size: 3487 bytes
Desc: not available
Url : http://lists.xwiki.org/pipermail/devs/attachments/20061019/ad240c3f/attachment.obj