Subject RE: [firebird-support] Moving data from one database to another
Author Andy Gable
I have actually decided to create a small data shunt application (at least I will know what is being moved around)


-----Original Message-----
From: [] On Behalf Of Thomas Steinmaurer
Sent: 08 January 2013 4:48 PM
Subject: Re: [firebird-support] Moving data from one database to another

> On Tue, 8 Jan 2013 14:56:19 -0000, "Andy Gable"
> <andrew.gable@...>
> 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
> ( ); 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.




Visit and click the Resources item on the main (top) menu. Try Knowledgebase and FAQ links !

Also search the knowledgebases at

Yahoo! Groups Links