BUG: Documentation error in the "Reinitializing a Subscription" topic in SQL Server CE 1.1 Books Online (325788)


The information in this article applies to:

  • Microsoft SQL Server 2000 Windows CE Edition 1.1
This article was previously published under Q325788
Bug #: 3771 (SSCE)
SSCE:3771

SYMPTOMS

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

"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."

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 "ReinitializeSubscription Method" topic in SQL Server CE 1.1 Books Online states the following:

"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."

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 object is the SQL Server CE replication object):
object.ReinitializeSubscription(VARIANT_BOOLbUploadBeforeReInit)
Modification Type:MajorLast Reviewed:1/5/2004
Keywords:kbmerge kbReplication kbOnlineDocs kbdocerr kbbug KB325788 kbAudDeveloper
©2003 Microsoft Corporation. All rights reserved.