-----------------------------------------------
Joseph B. Ottinger [EMAIL PROTECTED]
http://enigmastation.com IT Consultant
From: Mark Derricutt <[EMAIL PROTECTED]>
Reply-To: "JDJList" <[EMAIL PROTECTED]>
To: "JDJList" <[EMAIL PROTECTED]>
Subject: [jdjlist] Re: Data migration tools
Date: Fri, 18 Oct 2002 10:18:40 +1300
I ended up just writing a small class to select everything from each table in one db, and insert it into the other, doing minor mangling where needed (MSSQL bit fields to PostgreSQL booleans), and various fields to "text" or something. Solved the problem and was only needed once off.
Might even extend the code somemore to make it more generic to use the net time I might need something similiar.
--On Wednesday, October 02, 2002 08:17:54 -0400 Andy Bentley <[EMAIL PROTECTED]> wrote:
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.-- \m/ -- ...in 28 days - The Odyssey begins... www.symphonyx.com [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 ____________________________________________________
_________________________________________________________________
Surf the Web without missing calls! Get MSN Broadband. http://resourcecenter.msn.com/access/plans/freeactivation.asp
____________________________________________________
To change your JDJList options, please visit:
http://www.sys-con.com/java/list.cfm
Be respectful! Clean up your posts before replying
____________________________________________________
