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

Sync Services optimizations

    There are some optimizations that can be done for an “Sync Services” sync scenario. These are, (might not be an exhaustive list) Small sync chunks (using smaller SyncGroups which are only absolutely necessary) Index creation on tracking and filtering columns Transfer encryption of data payload on web Batching the changes                  Filtering the data at various…

0