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…

0

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…

1

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                              Compact type                  Format                                Date                                     nvarchar(10)                   ‘yyyy-mm-dd’ Time                                     nvarchar(16)                   ‘hh:mi:ss.nnnnnnn” Datetime2                            nvarchar(27)                   ‘yyyy-mm-dd…

1

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 Server Compact 3.1 Connectivity Tools.   This post is not applicable/refer-to Sync Services for…

12

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…

1

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 NOT need any extra configuration…

1

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/Internet proxy settings from the app to set the properties on SQL CE classes.  Here is the short story…

3

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…

2

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 the RDA system tables.  __sysMergeSubscriptions…

1

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 to BLOG about it J…

1