Moving data from one database to another

[Andy Gable]

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?



Andy



[Non-text portions of this message have been removed]

[Martijn Tonies]

Hello Andy,

Post by Andy Gable
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?

You can download a trial of Database Workbench at www.upscene.com
and use the DataPump to do this, see:
http://upscene.com/documentation/dbw4/tools_datapump.htm


Hope this helps.

With regards,

Martijn Tonies
Upscene Productions
http://www.upscene.com

Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!

[chris.waldmann]

Post by Andy Gable
Is this possible or do I need to make a sync app to do the move?

There is a very nice data pump available:

http://www.clevercomponents.com/products/datapump/index.asp

Regards
Christian

[SoftTech]

Wouldn't it be a better idea to create a database script from "your" development database and one from your "customers" database and then do a comparison of the two databases and then use an update script to update your customers database? This is what I do on a regular basis. If however, it is so far out of sync that this is not feasible, then I would follow Martijn Tonies suggestion.

Mike



----- Original Message -----
From: Andy Gable
To: firebird-***@yahoogroups.com
Sent: Tuesday, January 08, 2013 8:56 AM
Subject: {Disarmed} [firebird-support] Moving data from one database to another



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?

Andy

[Non-text portions of this message have been removed]




--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.

[Non-text portions of this message have been removed]

[Mark Rotteveel]

Post by Andy Gable
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

Post by Andy Gable
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.

Mark

[Thomas Steinmaurer]

Post by Andy Gable

Post by Andy Gable
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

Post by Andy Gable
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

[Andy Gable]

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-***@yahoogroups.com [mailto:firebird-***@yahoogroups.com] On Behalf Of Thomas Steinmaurer
Sent: 08 January 2013 4:48 PM
To: firebird-***@yahoogroups.com
Subject: Re: [firebird-support] Moving data from one database to another

On Tue, 8 Jan 2013 14:56:19 -0000, "Andy Gable"

Post by Andy Gable
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

Post by Andy Gable
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