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(a)us.ibm.com
"Philippe Legrain" <legrain(a)gmail.com>
10/19/2006 07:51 AM
Please respond to
xwiki-dev(a)objectweb.org
To
xwiki-dev(a)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(a)us.ibm.com < fanuzzi(a)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(a)objectweb.org
mailing list.
To unsubscribe: mailto: xwiki-dev-unsubscribe(a)objectweb.org
For general help: mailto:sympa@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(a)objectweb.org
mailing list.
To unsubscribe: mailto:xwiki-dev-unsubscribe@objectweb.org
For general help: mailto:sympa@objectweb.org?subject=help
ObjectWeb mailing lists service home page:
http://www.objectweb.org/wws