I'm trying to use SQL Server/Compact Framework 3 Merge Replication functionality and am running into a problem when calling Replication.SaveProperties (using c#). I was hoping to get some clarification on whether its my interpretation on how things should
work vs a coding problem.
Basically, the Merge Replication seems to work as I can sync information between my handheld and server databases. However, I've created a form on my handheld so that the user can change some synchronication settings (e.g. Publication or Publisher
Name) and then save it.
What I've noticed is :
1) You can NOT call Replication.SaveProperties until after a synchronization is performed (otherwise you get an error message). Assuming this is so that it can create the "__sysMergeSubscriptions" table. Does this sound right?
2) If I then try to change the saved Subscriber information via another call to Replication.SaveProperties (e.g. change the Publication info), I then get an error message that says:
The subscription was not found. Publisher, PublisherDatabase, or Publication could be incorrect.
Is this normal behavior? Does this mean that you can you NOT change subscriber information; only add or drop it?
View Complete Post