Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
SqlCeSyncProvider not detecting any changes. RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi,

    I am trying to Sync an SQL Compact database with an SQL Server Database. I am having a bit of a problem with the compact database. It's not detecting any changes. I am using the collaborative scenario.

    When I sync with the server downloads are applied to the the CE database but changes to the CE database are not uploaded.

    The ChangesSelected event on the CE provider is fired each sync but the dataset doesn't contain any rows.

    Does anyone have any tips on how to debug a problem like this?

     

    Regards

    Jared

     

     

    Thursday, April 29, 2010 12:40 AM

Answers

  • Question
    Sign in to vote
    1
    Sign in to vote

    try enabling the Sync FX tracing, if possible in verbose mode so you get to see all internal events firing.

    you might want to test using a new CE database as well, provision the sync scope, then do another test to isolate if something wrong happened during the provisioning part.

    • Marked as answer by Jared Kells Thursday, April 29, 2010 1:53 AM
    Thursday, April 29, 2010 12:51 AM

All replies

  • Question
    Sign in to vote
    1
    Sign in to vote

    try enabling the Sync FX tracing, if possible in verbose mode so you get to see all internal events firing.

    you might want to test using a new CE database as well, provision the sync scope, then do another test to isolate if something wrong happened during the provisioning part.

    • Marked as answer by Jared Kells Thursday, April 29, 2010 1:53 AM
    Thursday, April 29, 2010 12:51 AM
  • Question
    Sign in to vote
    0
    Sign in to vote
    Thanks JuneT, Just what I was looking for thanks.
    Thursday, April 29, 2010 1:53 AM