Merge replication vs. Sync Services for Compact

  SQL Server Compact supports predominantly two different sync technologies. “Merge replication” and “Sync Services”. Users might be using one or the other, and interested in knowing the differences between the two technologies, from a use-case point of view. Still, there might be others interested in knowing, which technology better suites their need, by comparing…


SQL CE Binaries – Details

  Many times developers get puzzled on which exact set of binaries one should consume in their application.  There is also a misconception that SQL CE engine is too big in size.  This may be because there was no effort from our side to clarify on “Which binary is for what purpose?”.  In an effort…

SQL Server Compact Garbage Collection – Whys and Hows

Some background about SQL Server Compact: SQL Server Compact is an embedded database implemented in native and it can be accessed in application by either OLEDB or ADO.NET provider model. ADO.NET provider for SQL Server Compact is a managed assembly which depends on native SQL Server Compact DLLs to provide the service. In general, the…


After moving the database from one platform to other, the first SqlCeConnection.Open() takes more time

    If you move a SQLCE database from one platform to other, it’s first SqlCeConnection.Open() takes more time and also increases the database file size.   The Reason: For an index on string type columns, SQLCE uses LCMapString API to get the normalized sort key. LCMapString API behavior will be different for different NLS sort versions….


Overview of SqlCeReplication methods – LoadProperties and SaveProperties

Whenever sync is started, developers provide all the necessary properties to an object of SqlCeReplication class. These properties are provided through the constructors or by directly setting the public properties of the object. In this approach developers need to provide this data for every sync, which forces them to store this data somewhere in their…