This forum is closed. Thank you for your contributions.

Sign in

Microsoft.com

Microsoft

Remove From My Forums

Synchronization using Sync framework from SQL Server Express to SQL Server 2008

Question
0

Sign in to vote
I am trying to find answers for a few questions on the framework. Some of which are:

Who is using it?
How long has it been in the market?
How much load can it sustain?
Fail over support
Security?
Overhead on my OLTP.

A case study on a scenario where there are multiple SQL express clients syncing data with 1 SQL server 2008 using change tracking would be of great help:
- Edited by Barun Meher Monday, September 15, 2014 12:48 PM
Monday, September 15, 2014 12:42 PM

All replies

0

Sign in to vote

1 - some of known MS products using it: http://jtabadero.wordpress.com/2012/02/08/microsoft-products-using-sync-framework/

2 - late 2007

3 - it's an SDK, not a service. the load is on the app you use it and the corresponding data stores you deal with

4 - again, it's an SDK

5 - it's an SDK, relies on how you protect your app and the part that syncs

6 - it has to track changes, so there's an overhead for every write operation

Wednesday, September 17, 2014 12:55 PM