Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
Sync Services for ADO.NET 1.0 + SqlCeEngine.Shrink RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    Good day Everybody!

    We're curently developing an application which uses Sync Services for ADO.NET to replicate smart device (WM 6.5) to SQL Server. Since the database size is rather large, periodically during application startup we call SqlCeEngine.Shrink to reduce mobile database size. I'm just interested if this method does not corrupt or delete change tracking information that is used for synchronization? Currently we experience no issues with that, but just in case.

    Thanx in advance.

    Thursday, July 28, 2011 10:20 AM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote
    afaik, SqlCeEngine.Shrink  simply truncates free/unallocated pages in the SDF and does not do anything on the contents of the in-use pages. so i dont think it has any effect on the actual data contents of the sdf or the change tracking metadata.
    • Proposed as answer by ErikEJMVP Saturday, July 30, 2011 2:52 PM
    • Marked as answer by Nuzik Saturday, July 30, 2011 9:46 PM
    Thursday, July 28, 2011 1:59 PM

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote
    afaik, SqlCeEngine.Shrink  simply truncates free/unallocated pages in the SDF and does not do anything on the contents of the in-use pages. so i dont think it has any effect on the actual data contents of the sdf or the change tracking metadata.
    • Proposed as answer by ErikEJMVP Saturday, July 30, 2011 2:52 PM
    • Marked as answer by Nuzik Saturday, July 30, 2011 9:46 PM
    Thursday, July 28, 2011 1:59 PM
  • Question
    Sign in to vote
    0
    Sign in to vote
    afaik, SqlCeEngine.Shrink  simply truncates free/unallocated pages in the SDF and does not do anything on the contents of the in-use pages. so i dont think it has any effect on the actual data contents of the sdf or the change tracking metadata.

    Thank you for a reply. Since we have dozens of troubles with f**ng Sync Framework, now I prefer do recheck everything twice...
    Rgds, Nazar Andrienko
    Thursday, July 28, 2011 2:21 PM
  • Question
    Sign in to vote
    0
    Sign in to vote
    the same framework saved you dozens of hours writing your own sync code from scratch. just because you cant make things work with the framework doesnt mean its broken.
    Thursday, July 28, 2011 11:10 PM