Atomikos Forum

Hi there,

I am planning to transfer data between two Xa datasources. Is there any best practice advice to this problem?

Currently I am planning to initialize two atomikos datasource bean separately with each datasource, then load data from one datasource and upload it to the other (remote).

I am not sure if there is a better way to do this, but any advice, fail-safe suggestion or datasourcebean configuration recommendations are welcomed

thanks in advance! yudi

Hi,

You could also use a queue in between, so you have two processes:

-one process to extract from the source database and put things onto the queue

-one process to read from the queue and insert in the target database

Keep in mind that queues can switch the order of messages so don't do this if the order between messages/updates is important (for instance, foreign key references between updates should go in the same message). However, this solution does decrease the coupling between your databases.

The best solution depends on your requirements, and the uptime of both databases.

HTH