How to have partial incremental synchronizations based on a GUID?
Posted
by Gonçalo Veiga
on Stack Overflow
See other posts from Stack Overflow
or by Gonçalo Veiga
Published on 2009-03-03T10:59:15Z
Indexed on
2010/04/03
16:03 UTC
Read the original article
Hit count: 211
I need to synchronize an SQL Server database to Oracle through an Oracle Transparent Gateway. The synchronization is performed in batches, so I need to get the next set of data from the point where I left off.
The problem I'm having is that the only field I have in the source, to help me, is a GUID. If it were a number I could just order by it, keep the last one processed and restart the process by getting the records which are > my recorded number. This won't work with a GUID.
Any ideas?
© Stack Overflow or respective owner