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: 213

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

Related posts about sql-server

Related posts about Oracle