Sqlserver database replication for azure
Scenario: I have a server farm to deploy my website. I want to try and add one server from the Azure platform. Each host has replication from one database server. I tried to add a replication database, but I got an error:
Microsoft SQL Server Management Studio cannot access component replication because replication is not installed on this instance of SQL Server. For information about installing replication, see the topic Installing Replication in SQL Server Books Online. (New Subscription Wizard)
After this post, I am guessing something is missing on the Azure sqlserver database side.
I have googled something to solve my problem, but with no luck.
I found one tool (Azure SQL Data Sync) and tried to solve something, but it didn't work. From the Azure documentation, I found that until A12 database replication for V12 is available. But what about v12?
Questions: Am I missing something with the database version? Do I need to change the database plan in my Azure subscription? Should I use some external tool that allows me to keep my database server in sync with replication?
source to share
Replication is not yet available according to MSDN even on V12. You can use https://azure.microsoft.com/en-us/documentation/articles/data-factory-introduction/ and https://azure.microsoft.com/en-us/documentation/articles/sql-database- get-started-sql-data-sync / . You can write your own synchronization logic with change tracking, service broker and linked servers / secure CLR, but it is better to use existing tools.
source to share
Perhaps Azure Data Factory Service might be the solution for you? https://azure.microsoft.com/en-us/documentation/articles/data-factory-introduction/
source to share