BizTalk Server Orchestration - Synchronization of Data

Author

Synchronization of Data

CranCran77

2006-02-28, 7:49 am

I have one database where I need to synchronize the records in this
database with another system on a specified interval. How have others
done this in your orchestrations in order to prevent multiple
executions and to make sure these executions occur at the specified
intervals?

ashok.sandya@gmail.com

2006-03-03, 6:17 pm

You can write an orchestration that polls the database using the SQL
adapter in the receive port. You can setup polling intervals in the
adapter.
Once you receive data from this DB into the orchestration, you can then
call the other database either by using the SQL adapter in the send
port or by calling your own component that does this.

Hope this helps
Ashok