Partager via

New service update available for SQL Data Sync!

  • Article

While it has been 3+ years since we last announced an update to SQL Data Sync service, we have been continuously deploying updates to the backend service to address top customer issues.  We are listening to your feedback, and today we are happy to announce the latest update which includes both service changes and a new SQL Data Sync agent install.  This update includes two main enhancements:

  1. Support for synchronizing tables that have column collations:
    • If the selected sync schema tables do not already exist in your hub or member databases, upon deploying the sync group, SQL Data Sync will automatically create corresponding tables and columns in the empty database with the same collation settings as the select sync schema.
    • If the tables to-be-synced are already created in both hub and member databases, SQL Data Sync requires the primary key columns have the same collation between hub/member databases to successfully deploy the sync group.  There is no collation restriction on the non-primary key columns.
  2. Improvements to performance and resilience:
    • We enhanced batch transfer of serialized changes from source to destination, so you should see faster sync throughput.
    • We improved transient error handling logic when reading from the source or writing to the destination.

The new version of SQL Data Sync agent in the download center.  Please follow the step-by-step instructions here to install a new Data Sync agent.  If you have an existing agent, you can refer to this MSDN article for detailed upgrade procedures.  A previous version of Data Sync agent will continue to work until it expires on 8/18/2015.

Comments

  • Anonymous
    May 28, 2015
    Cheer! Can't wait to upgrade to the latest version!

  • Anonymous
    June 04, 2015
    Noticed i lose the ability to use SSDT to generate a deployment preview when a database is added to SQL Data Sync. Is this a bug / intended behavior?

  • Anonymous
    June 06, 2015
    @Zach, could you please provide more details about the issue you encountered? Generally, SQL Data Sync service/local agent won't "lock" any object on a database joined sync.

  • Anonymous
    August 17, 2015
    I just installed SyncSDK-v2.1-x64-ENU.msi  on my win7 desktop and in following the walkthrough demo on the web I discovered that I couldn't add a reference to "Microsoft.Synchronization.Data". What else do I need to install to get the assembly containing this reference?

  • Anonymous
    January 10, 2016
    The comment has been removed

  • Anonymous
    January 23, 2016
    Hi. same as Tommy we are about to start a new project and could be usefull to know about the actual state of MSF. There is plans to maintain it? Is MSF a dead project ?

  • Anonymous
    March 14, 2016
    Hello...is anyone out there. Please confirm either way. Is this great tool staying...going into production or ultimately going to die? 9 months since the last update is pretty poor!