Couple of ways to do this... depending on the environment you are in.
One simpler way are to use the database-specific tools to export and import functionalities. This might not be as easy as it sounds across database types as there are differences in dump-file formats and by which the data-types, catalogs & schemas are handled... So, this solution could be very subjective... Another way is, if you have JDBC drivers for both databases, you can use Java to load both drivers, open connections to both databases and execute queries to collect data and process them if needed and write them back to the new database. Good amount of coding and testing is needed... Or, the easiest way is to use AltoWeb! AltoWeb has a concept of MetaObjects. You can create Data-Objects out of Database tables each from different types of databases (if you like) and can graphically design a Business process by assembling standard-components provided by AltoWeb and transfer data from one MetaObject to the Other, without breaking a sweat! But, the price for the convenience is, you need to have an AppServer, AltoWeb and a little learning curve... Did I mention there are eval-downloads of these for free? Cheers, -Madhu. -----Original Message----- From: Mark Derricutt [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 01, 2002 2:44 PM To: JDJList Subject: [jdjlist] Data migration tools 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 ____________________________________________________
