Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

SQL Azure Merge Replication

Does anyone know if SQL Azure supports merge replication? I am currently working with the web version of SQL 2008 R2 and it does not support the publication side of replication and I need a solution that will that doesn't cost $7000.

like image 226
CoderMarkus Avatar asked May 24 '12 15:05

CoderMarkus


People also ask

What is SQL merge replication?

Merge replication is a method for copying and distributing data and database objects from one SQL Server database to another followed by synchronizing the databases for consistency. The other methods for replication of SQL databases are snapshot replication and transactional replication.

Does Azure SQL support replication?

Transactional replication is a feature of Azure SQL Managed Instance and SQL Server that enables you to replicate data from a table in Azure SQL Managed Instance or a SQL Server instance to tables placed on remote databases. This feature allows you to synchronize multiple tables in different databases.

What is difference between merge replication and replication?

Merge Replication is the same as SQL Server Transactional replication; however, Merge replication replicates data from the Publisher to Subscriber and vice-a-versa.


2 Answers

SQL Azure Database does not provide replication currently.

http://msdn.microsoft.com/en-us/library/windowsazure/ff394115.aspx

However, there is the SQL Azure Data Sync service (currently in preview).

like image 186
David Pallmann Avatar answered Oct 02 '22 13:10

David Pallmann


and if the Sql Azure Data Sync Service doesnt meet your needs, you can always write your own...

see: Walkthrough of Windows Azure Sync Service Sample

like image 41
JuneT Avatar answered Oct 02 '22 12:10

JuneT