I have actually decided to create a small data shunt application (at least I will know what is being moved around)
Andy -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Thomas Steinmaurer Sent: 08 January 2013 4:48 PM To: [email protected] Subject: Re: [firebird-support] Moving data from one database to another > On Tue, 8 Jan 2013 14:56:19 -0000, "Andy Gable" > <[email protected]> > wrote: >> Hi all, >> >> what tool can I use to move data from one database and insert it into >> another database? >> >> basically I have changed some tables with in my database and I have >> customers who use my >> >> System so I want to move their data from the old style to the new > database >> >> >> >> Is this possible or do I need to make a sync app to do the move? > > If you need specific, complex transformations of your data (and not > simply pump data), you could also look at Pentaho Kettle > (http://kettle.pentaho.com/ ); it is actually intended for Business > Intelligence, ETL etc, but I have found that it can also be (ab)used > for data migrations. Kettle aka Pentaho Data Integration is an excellent product and extensible, e.g. to plug in a Firebird Event Listener step. Used it in various open source DWH projects in the past. Regards, Thomas ------------------------------------ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Visit http://www.firebirdsql.org and click the Resources item on the main (top) menu. Try Knowledgebase and FAQ links ! Also search the knowledgebases at http://www.ibphoenix.com ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Yahoo! Groups Links
