Subject Re: [IBO] Moving data from one database to another using Tib_import/export. Surrogate key?
Author Helen Borrie
At 09:36 AM 16/01/2010, Jason Wharton wrote:
>Helen,
>
>Are you talking about the TIB_DataPump component?

Ooops, yes, sorry!


>If the data is substantial in size it may be a much faster route to use a
>text file, compress it, send it over the wire, decompress it, load it in.

Good point. Also, if replication is really the objective, rather than just a one-off serial sync of data from multiple databases, there are replication products out there that support "off-line replication", which can be a better option than fully converting and reconverting data...

Helen