There is basically 2 pieces to this:
1) DB structure
2) Data in the DB
I assume you want to migrate to a different RDBMS like DB2 to Oracle?
1) find the old DB2 .sql build script for your tables and modify SQL so it works for Oracle. Might take a few tries.
2) write a simple sql script that will spit out 1-table at a time as a space or comma-delimited data, then use SQLLoader or some other utility like that to load your data. If you do not want to use SQL loader, write some simple SQL "SELECT * " or a Java utility that will spit the data out in this format:
insert('valA', 1, 233434.45, 'valB') into TABLEA;
.
.
.
you might need to concatenate some strings creatively in SQL or Java to do this. SQL might be easier.
Best of luck,
Greg N.
-----Original Message-----
From: Andy Bentley [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 02, 2002 5:18 AM
To: JDJList
Subject: [jdjlist] Re: Data migration tools
Might want to try to bypass jdbc altogether. Most DBs have IMPORT &
EXPORT facilities. Use EXPORT to get data out of DB into Comma
Delimited files and use IMPORT to import the data into your new DB.
Mark Derricutt wrote:
>
> Hiya, not quite a java programming question, more a java tool hunt...
>
> I'm looking for a tool to migrate data from one jdbc datasource to another,
> I only need it to be a once off migration, but may need something similar
> in the future.
>
> Is there anything out there for this? Or shall I just bite the bullet and
> write some code to do it manually (which I'll probably end up doing
> anything).
>
> Mark
>
> -- \m/ --
> "...if I seem super human I have been misunderstood." (c) Dream Theater
> [EMAIL PROTECTED] - ICQ: 1934853 JID: [EMAIL PROTECTED]
>
> ____________________________________________________
> To change your JDJList options, please visit:
> http://www.sys-con.com/java/list.cfm
>
> Be respectful! Clean up your posts before replying
> ____________________________________________________
____________________________________________________
To change your JDJList options, please visit:
http://www.sys-con.com/java/list.cfm
Be respectful! Clean up your posts before replying
____________________________________________________
To change your JDJList options, please visit:
http://www.sys-con.com/java/list.cfm
Be respectful! Clean up your posts before replying
____________________________________________________
