SQLce detec unsynced changes and inserts RRS feed

  • Question

  • Hi there,

    I am trying to detect rows in my client database that have not synchronized to the server (both changes and inserts). The client is an SQLCE DB and the server is SQL Azure. Sync occurs over WCF services. I know I can hook up the ChangesSelected event - but that seems to require a round trip to the server and I'm trying to avoid that.

    I have recorded the last sync time - and can get the rows that have changed on the client by querying the tracking table in the SQLCE client DB. Newly inserted rows do not appear in the tracking table. Is is safe to assume that newly inserted rows are represented by rows that are in the base table and do not have corresponding rows in the tracking table?

    If not, what is the best way to detect newly inserted rows on the client?

    Thanks in advance for any help.


    Monday, April 16, 2012 9:02 PM

All replies