Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
Azure Sql Sync Framework- Can we fetch timestamp RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    I want to fetch records from my on premise database that would be in sync with Azure in the next sync cycle. I have developed an application that does all the sync + migration activity. I know that an SP by the name of <Table>_selectchanges, that was provisioned by Azure would run and would get me all the records that would be modified at Azure end in this cycle. Can I somehow get the timestamp value that would be used to check the records that would be selected from premise database for sync?

    Note: this value is an argument to selectChanges SP and is named @sync_min_timestamp

    Tuesday, May 11, 2010 9:44 AM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi,

    This kind of usage is not a supported scenario from SyncFx. If you want to use this stored procedure just for fetching incremental changes, you can provision a SQL Server database with the database provider management APIs and use SQL Server Profiler to find out how this SP is used.

    In database provider end-to-end sync scenario, the value of @sync_min_timestamp comes from remote sync endpoint. It represents what the remote sync endpoint knowledge of the local sync endpoint based on their previous sync. It means that you should record min_active_rowversion() in some place when you call this SP last time, and use the recorded value as @sync_min_timestamp when calling this SP again.

    You need to make sure that the value is recorded at the right time and in the right transaction to avoid re-enumeration or missing changes

    Thanks,

    Dong

    This posting is provided AS IS with no warranties, and confers no rights.
    Tuesday, May 11, 2010 6:52 PM