After you execute the SqlCeEngine.Compact method against a SQL Server Compact 3.5 client database that is synchronized to a central database server, some changes to the client database may not be uploaded

Article translations Article translations
Article ID: 967502 - View products that this article applies to.
Expand all | Collapse all

On This Page

RAPID PUBLISHING

RAPID PUBLISHING ARTICLES PROVIDE INFORMATION IN RESPONSE TO EMERGING OR UNIQUE TOPICS, AND MAY BE UPDATED AS NEW INFORMATION BECOMES AVAILABLE.

SYMPTOMS

You have a SQL Server Compact 3.5 client database that is synchronized toa central database server by using Microsoft Synchronization Services for ADO.NET. Then, you execute the SqlCeEngine.Compact method against the database. After you change the client database and perform the synchronization, some changes are not uploaded to the central database server.

WORKAROUND

To work around this problem, use the SqlCeEngine.Shrink method to reclaim space in a SQL Server Compact 3.5 client database.

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
MICROSOFT AND/OR ITS RESPECTIVE SUPPLIERS MAKE NO REPRESENTATIONS ABOUT THE SUITABILITY OF THE INFORMATION CONTAINED IN THE DOCUMENTS AND RELATED GRAPHICS PUBLISHED ON THIS WEBSITE FOR ANY PURPOSE. THE DOCUMENTS AND RELATED GRAPHICS PUBLISHED ON THIS WEBSITE COULD INCLUDE TECHNICAL INACCURACIES OR TYPOGRAPHICAL ERRORS. CHANGES ARE PERIODICALLY ADDED TO THE INFORMATION HEREIN. MICROSOFT AND/OR ITS RESPECTIVE SUPPLIERS MAY MAKE IMPROVEMENTS AND/OR CHANGES IN THE PRODUCT(S) AND/OR THE PROGRAM(S) DESCRIBED HEREIN AT ANY TIME.

For more information about the terms of use, visit the following Web site:
http://support.microsoft.com/tou/

Properties

Article ID: 967502 - Last Review: February 10, 2009 - Revision: 1.0
APPLIES TO
  • Microsoft SQL Server Compact 3.5
Keywords: 
kbtshoot kbsurveynew kbexpertiseadvanced kbprb kbrapidpub KB967502

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com