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

SQL Server Compact is a SKU of SQL Server family of products from Microsoft. This is a thin light-weight, embedded, in-proc database engine which supports synchronization to SQL Server, etc.

Browse by Tags

Tagged Content List
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: Katmai new datatypes support

    In Katmai, new datatypes are introduced. Some of these (including some older types in Yukon) are supported for merge replication synching with SQL Compact in SQL Compact 3.5 SP1. These types are mapped to downlevel compatible types for SSC. These types and their mappings are, as follows: SQL type...
  • Blog Post: Connectivity Cross Version Compatibility (SQL Server Compact 3.5)

    Connectivity Cross Version Compatibility This blog post explains the Merge Replication connectivity cross version compatibility scenarios for the SQL Server Compact 3.5 release. For more information about the connectivity cross version compatibility scenarios in SQL Server Compact 3.1, see SQL...
  • Blog Post: Merge Subscribe Once, Copy and Deploy Multiple Times

    "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 going to bring down lot of data from server to client...
  • Blog Post: HOWTO: Pending Changes for a Merge Subscription (Server Side)

    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 of Remote Data Access (RDA). Note that, RDA does...
  • Blog Post: HTTP/Internet Proxy Detection - Using WINCE API

    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 comes on how to programmatically detect the HTTP...
  • Blog Post: HOWTO: Pending Changes for a Merge Subscription (Client Side)

    Often there will be need to find out if there are any pending changes on client side to upload. Note that, It is always better to avoid empty sync both from the resource (network bandwidth, web server, SQL Server) usage and performance. This blog post discusses on how to find if there are any pending...
  • Blog Post: Merge Replication System Tables

    The earlier blog post “ How to: Detect the database is merge replicated ”, gave a list of the system tables that get created in a merge subscription database. This blog post explains brief description of each of the system tables. There is another blog post “ RDA Subscriptions ” that describes briefly...
  • Blog Post: Replication and Database Mirroring (Failover) Support

    Replication and Database Mirroring (Failover) support for Merge Replication between SQL Server 2005 SP1+ and SQL Server 2005 Compact Edition (Mobile Edition SP1+) is supported but it was not documented as the support was added after RTM and the documentation was not updated. Then comes for me an opportunity...
  • Blog Post: HOWTO: Detect the database is Merge Replicated?

    Sometimes an application may want to know whether the database is in good shape in terms of Merge Replication especially when the merge replication is aborted by the user, or due to connection failure or many other reasons. Here are the things application should ideally check if the database is merge...
  • Blog Post: Annoying error - 28559 - Encountered problems when opening the database

    We have been hearing lot of complaints on how to get more information for error 28559 when doing RDA or Merge Replication. If you are using managed API (SqlCeReplication OR SqlCeRemoteDataAccess), then it should be straight forward for you as you would be receiving SqlCeErrorCollection in SqlCeException...
Page 1 of 1 (12 items)