I would like to reproduce exactly the datasets returned by the stored procedures created by Sync Framework 2.1. In particular, I would like to reproduce the dataset returned by the select changes procedure
Schematically, the query looks like
USE [<table>]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[<table>_selectchanges]
@sync_min_timestamp BigInt,
@sync_scope_local_id Int,
@sync_scope_restore_count Int,
@sync_update_peer_key Int
AS
BEGIN
SELECT [side].[<field1>],
......
END
If I try to execute the query from SSMS, SSMS requests me to provide values for the parameters @sync_min_timestamp, @sync_scope_local_id, @sync_scope_restore_count, @sync_update_peer_key.
How do I obtain the values @sync_min_timestamp, @sync_scope_local_id, @sync_scope_restore_count, @sync_update_peer_key?
I have looked through this forum and I have found multiple discussions but nothing that spells sync framework methods to call or queries to execute to obtain these values. JuneT does provide a code snippet in his post of 2010/03/05
https://jtabadero.wordpress.com/2010/03/05/passing-dynamic-filter-values-to-sync-framework-collaboration-scenario-sync-scopes/
Does this code snippet accurately reproduce the parameter values used by SYnc framework 2.1?
Howard P. Weiss