How is database synchronization achieved now with Sql Server 2012?

Question

In Sql Server 2008, Database Synchronization between a local installation of SQL Server Express on a client machine and SQL Server on a server could be done by using the Microsoft Sync Framework: http://msdn.microsoft.com/en-gb/sync/bb887608

How are Occasionally Connected Applications achieved now with SQL Server 2012 ?

i.e. say I had an Occasionally Connected Application on a client utilising Sql Server 2012 Express LocalDB, do we still use the above Sync Framework to perform Database Synchronization with the server or is there some other method now?

Can anyone point me to the current guidance on this?

Answer 1

Hi,

Sync Framework is not included in the SQL Server 2012 installation package. You can download and install the appropriate version of Sync Framework from here.

Although there is no new release of Sync Framework or SQL Azure Data Sync specifically for SQL 2012, current Sync Framework and SQL Azure Data Sync releases still works with SQL 2012.

Here is a blog for your reference: SQL SERVER 2012, SQL EXPRESS 2012 LOCALDB, SYNC FRAMEWORK, SYNC FRAMEWORK V4 AND SQL AZURE DATA SYNC

Hope this helps.

---

Vincent Wang

TechNet Community Support

Answer 2

I did find this:

Programming Microsoft SQL Server 2012 by Leonard Lobel & Andrew Brust (MS Press) - chapter 13 covers building occasionally connected systems that incorporate SQL Azure Data Sync, Windows Azure and the Windows Phone 7 development platform. In the sample solution, on the back end, an on-premise SQL Server database is kept synchronized with a public facing SQL Azure database in the cloud using SQL Azure Data Sync. The cloud database is exposed using WCF Data Services (also hosted in the cloud by deploying to Windows Azure) and consumed via OData by a mobile client application running on a Windows Phone 7 device. The sample solution detailed in this chapter demonstrates how these technologies work to keep data in sync across on-premise SQL Server, SQL Azure databases in the cloud, and local storage on Windows Phone 7 devices.