SQL Azure Merge Replication

Question

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.

After looking through a bunch of vague product description pages, I finally called Microsoft and after being transferred 4 times talked to someone who put a ticket in for me... Hopefully someone will be able to answer my question. — CoderMarkus, May 24 '12 at 16:59

score 10 · Accepted Answer · edited May 14 '19 at 08:35

10

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).

edited May 14 '19 at 08:35

SteveC

15,808
23
102
173

answered May 24 '12 at 17:23

David Pallmann

542
4
9

Thanks David. I totally missed the limitations section. The data sync service sounds great, I guess its worth a try for $10/mo. – CoderMarkus May 24 '12 at 17:36
Is this still the case? – cs0815 May 27 '15 at 17:47
1

@csetzkorn No more the case, see https://msdn.microsoft.com/library/mt589530.aspx But there is still a significant limitation, only one-way (push) replication is allowed – moudrick Aug 03 '16 at 09:18

score 2 · Answer 2 · answered May 25 '12 at 01:34

2

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

answered May 25 '12 at 01:34

JuneT

7,840
2
15
14

score 0 · Answer 3 · answered May 24 '12 at 17:34

0

As @DavidPallman points out, there's no replication today (aside from Sync Services).

In addition to the MSDN article he points to, there's a TechNet article comparing SQL Azure to SQL Server.

answered May 24 '12 at 17:34

David Makogon

69,407
21
141
189

score 0 · Answer 4 · answered Apr 14 '16 at 14:00

This question was asked some years ago, but for people that would be asking a similar question, it seems that transactional replication to Azure SQL DB is available (public preview) since November 2015. Source: https://azure.microsoft.com/en-us/blog/transactional-replication-to-azure-sql-db/ Regards.

SQL Azure Merge Replication

4 Answers4