Microsoft KB Archive/325788

= BUG: Documentation error in the &quot;Reinitializing a Subscription&quot; topic in SQL Server CE 1.1 Books Online =

Article ID: 325788

Article Last Modified on 1/5/2004

-

APPLIES TO


 * Microsoft SQL Server 2000 Windows CE Edition 1.1

-



This article was previously published under Q325788



Bug #: 3771 (SSCE)



SYMPTOMS
In Microsoft SQL Server 2000 Windows CE Edition 1.1 Books Online, the &quot;Reinitializing a Subscription&quot; topic contains the following paragraph:

&quot;Any unmerged changes that were present in the replica are discarded when the existing replica is deleted. SQL Server CE replication makes no attempt to merge the changes into the SQL Server publication before deleting the replica. If you want to merge the change from the replica into the SQL Server publication, you should perform synchronization rather than reinitialization.&quot;

Note This information is not correct. The unmerged changes that are present at the subscriber are not necessarily lost when you reinitialize a subscription. SQL Server CE 1.1 provides the option to upload the unmerged changes to the publisher when you reinitialize the subscription.



STATUS
Microsoft has confirmed that this is a bug in SQL Server CE 1.1 Books Online.

This bug was corrected in SQL Server CE 2.0 Books Online.



MORE INFORMATION
The &quot;ReinitializeSubscription Method&quot; topic in SQL Server CE 1.1 Books Online states the following:

&quot;bUploadBeforeReInit Indicates whether the SQL Server CE database should upload a message before reinitializing the subscription. This is a BOOLEAN value. The default is FALSE, meaning not to upload.&quot;

Therefore, you can upload the unmerged changes when you reinitialize the subscription by invoking the ReinitializeSubscription method and setting the bUploadBeforeReInit parameter to TRUE. However, if you invoke the ReinitializeSubscription method and you do not set the bUploadBeforeReInit parameter to TRUE, a new snapshot is applied on the subscribing database and any changes that have not been uploaded are lost.

You can invoke the ReinitializeSubscription method to reinitialize the subscription by using the following code (where  is the SQL Server CE replication object): object.ReinitializeSubscription(VARIANT_BOOLbUploadBeforeReInit)

Keywords: kbbug kbonlinedocs kbmerge kbdocerr kbreplication KB325788

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.