Reinit Merge Replication Subscription


There should be an option (like in SQL Server Managment Studio 2008, see attached screenshot) to force reinitialization (with or without upload changes). Currently if reinitialization is required there is no way to force it. So add an option to enable this to the Sync form, and call http://msdn.microsoft.com/en-us/library/system.data.sqlserverce.sqlcereplication.reinitializesubscription(v=vs.90).aspx with the selected option

file attachments

Closed Jan 28, 2013 at 11:12 AM by ErikEJ
In 3.3


ErikEJ wrote Jan 11, 2013 at 11:02 AM

Is the error not displayed - do you mean display no Message box, just display as text in the output window?
I will consider your other proposals for the next release

msmolka wrote Jan 11, 2013 at 11:47 AM

I've started testing today and it looked like that:
Started Sync, it started and seen progress in log window (the small box on the bottom).
Hower replication fired error "Try resynchronize". I couldn't see anything else from error message. But I know that this has more message to display, since it is from replicatiin. E.g. retenction period metatada cleanup.
This error message was Toolbox error message (like toolbox crash). But it wasn't crash in any way. It was just error from replication. So error can be displayed in output window. It doesn't have to be popup or similar thing. Just display everything possible.

ErikEJ wrote Jan 11, 2013 at 12:51 PM

I have updated to version on VS Gallery, could you let me know if this sorts your issue?

msmolka wrote Jan 11, 2013 at 1:05 PM

When I see latest version in vs gallery I will test and let you know. Currently even if I remove and add toolbox it still adds version Also in gallery I cannot find the version you mentioned yet.

ErikEJ wrote Jan 12, 2013 at 9:56 AM

Sorry, forgot to hit save, it is there now...

msmolka wrote Jan 14, 2013 at 9:11 AM

I can now see all errors in output window. Thanks for that.
Waiting for reinitialization option.

wrote Jan 15, 2013 at 10:47 AM

Associated with changeset 82289.

ErikEJ wrote Jan 15, 2013 at 10:50 AM

I have uploaded a "private build" - let me know if this Works for you...

msmolka wrote Jan 16, 2013 at 11:38 AM

No, I'm afraid it is not working. When I press Reinitialize (any) it shows Error windows saying Required property is not specified (Publisher). But this property is there becuase it is used by SYNC.

BTW. The only difference between normar sync and reinialization is calling code similar to:

It looks like in your code you separted reinitialization from normal sync. But it shouldn't be like that. Renitailziationn to code is just one additinal metod called.

ErikEJ wrote Jan 17, 2013 at 1:34 PM

Thanks for the feedback - I have not seperated this from normal sync. it is just the UI. But it looks like I was calling Reinit too early in my replication library - will fix and re-upload.

ErikEJ wrote Jan 18, 2013 at 9:10 AM

Uploaded new build to this issue as attachment, should Work now, thanks for your patience

wrote Jan 18, 2013 at 11:01 AM

Associated with changeset 82365.

msmolka wrote Jan 21, 2013 at 11:57 AM

I've tested the latest change and now it is working. BTW. Would it be possible to make output window bigger or sizable? With reinitialization there is quite a lot info and sometimes difficult to see becuase scrolling is required.

ErikEJ wrote Jan 21, 2013 at 1:12 PM

Glad to hear it is working, will look at the textbox size....