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.
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.
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.
Merge Replication is the same as SQL Server Transactional replication; however, Merge replication replicates data from the Publisher to Subscriber and vice-a-versa.
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).
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
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With