Wednesday, March 7, 2012

Replication Monitor SqlServerCE

I have developed a smart device application using SqlServerCE that replicates data to the backend server. I need to provide to the user a status of this replication process. I read about the "MergeSubscriberMonitor" in SQL Server but can't find it in SqlServerCe. Is this possible? Can someone please point me in the right direction?You need to wait for synchronisation to finish and then you can query to MergeReplication object to report on the data transferred.

If you were using SQLMobile (the CE version for SQL 2005), there is messaging available that will give you progress updates.|||I'm not sure I understand what your comment "messaging" is referring to. Do you have or can point me to some sample code that uses messaging? I am using SQL CE on the mobile device.|||Sorry, by messaging I mean events that you can catch within code and then react to. With SQL CE I don't believe this is happening. You can only query the replication object at the completion of the synchronisation process in order to determine what the outcome was (data sent and received)|||Thanks for your response. I did try asynchronous replication and it is working well so far. I need to implement some additional error trapping but I think I have 95% of what I need. It allows me to get a "percent of completion" during the sync process. I can then display this on the screen to my users. The database is VERY large and was taking forever to sync. I really needed some type of progress bar to show the user. Without that status update, it appeared the unit was locked up. Thanks anyway for your reponse.|||Hi,

I am also trying to get a status update on each article during the web synchronization process. Can you please update me on how to monitor the percent complete progress for the replication.

Thanks in advance.

Apurva

No comments:

Post a Comment