Microsoft's Embedded Database - SQL Server Compact - Team Blog

"Merge Subscribe Once, Copy and Deploy Multiple Times" - This has been the real good feature I like and unfortunately not many people knew about it. This is applicable for v3.0 and above. Here is a short story of it: The initial subscription is...

Earlier in the other blog article we discussed on “ HOWTO: Pending Changes for a Merge Subscription (Client Side) ” and this article will focus on finding the pending changes on server side for download. This blog article requires a little understanding...

SqlCeReplication and SqlCeRemoteDataAccess have InternetProxyServer, InternetProxyLogin, InternetProxyPassword properties which the application can set to make these sync protocols communicate via/thru the desired proxy. However, then the question...

In this article, we will discuss the Connection String Parameters that are meant for use only for database creation and not for connection open to an existing database. Locale Identifier – LCID tells the engine in which locale/collation the database...

Maximum Database Size is NOT a persistent configuration (It is NOT stored in database file). SQL CE creates shared memory to support multi-connection scenarios. SQL CE maintains an entry for each page of the database file, in this shared memory. Because...