none
Sync doesnot reflect the updated rows RRS feed

  • Question

  • Hello,

    I am trying to use the Sync Frame work to sync between a local SQL and SQL Azure. When I insert a new row and sync, it works fine both directions. But when I update an existing row, the update is not reflected. Any idea why ? As far as I understand it is supposed to get updated.

    I am using the SyncOrchestrator
    syncOrchestrator.Synchronize();
    I followed this video tutorial http://msdn.microsoft.com/en-us/azure/ee960244.aspx

    In there it shows that when a row is updated it is actually synced properly but doesnot work in my case.

    I also tried running SyncLocalSqlAzureDatabase.exe which comes with the Power pack for SQL November CTP, and it also doesnt sync the  rows that have been updated/modified, only syncs the new rows that are added and the rows which are deleted.

    Any help would be much appriciated. Thank you inadvance.

    Sunday, February 14, 2010 5:49 PM

Answers

  • There are a few things we can start to debug.

    1. If you make only one UPDATE (not on PK column) on the SQL Server, does the change go to the SQL Azure?
    2. If you make only one UPDATE (not on PK column) on the SQL Azure, does the change go to SQL Server?

    You please look for the update the results from SSMS (SQL management studio) on the SQL Azure and SQL Server.

    Thanks.
    Leo Zhou ------ This posting is provided "AS IS" with no warranties, and confers no rights.
    Monday, February 15, 2010 5:45 PM
    Answerer

All replies

  • There are a few things we can start to debug.

    1. If you make only one UPDATE (not on PK column) on the SQL Server, does the change go to the SQL Azure?
    2. If you make only one UPDATE (not on PK column) on the SQL Azure, does the change go to SQL Server?

    You please look for the update the results from SSMS (SQL management studio) on the SQL Azure and SQL Server.

    Thanks.
    Leo Zhou ------ This posting is provided "AS IS" with no warranties, and confers no rights.
    Monday, February 15, 2010 5:45 PM
    Answerer
  • can you also check to see if the Updated rows were tracked correctly to the tracking table ? if it does, you might need to trace the sync and check the trace log to see if the rows were picked up by the select change command and send over to the other end point ( in this case, it could be your SqlAzure db ), and if see what command were used to updat the table ( if the rows were sent ). with that, we would know where the problem would be.

    thanks
    Yunwen
    This posting is provided "AS IS" with no warranties, and confers no rights.
    Tuesday, February 16, 2010 9:26 AM
    Moderator