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

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

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.Errors which would contain list of errors.  This list would…

1

RDA Subscriptions

  Q1.  How do I know whether the RDA Pulled table is tracked or not? OR What an RDA Subscribed table means? A1.  RDA Subscriptions are maintained in a system table __sysRDASubscriptions.  If the table is pulled with tracking ON (that is RdaTrackOption.TrackingOn or RdaTrackOption.TrackingOnWithIndexes), then it means it is RDA Subscribed.  Hence, an entry…

1