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: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] On Behalf Of Thomas Steinmaurer
Sent: 08 January 2013 4:48 PM
To: firebird-support@yahoogroups.com
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
> (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