Reputation: 7558
Scenario: I have a server farm to deploy my web site. I want to try to add one server from Azure platform. Every host has a replication from one database server. I have tried to add the replication database but I got this message error:
Microsoft SQL Server Management Studio is unable to access replication components 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 message I suppose that something is missing in the sqlserver database Azure side.
I have googled something to solve my problem but without luck.
I have found one tool (Azure SQL Data Sync) and tried something to solve the problem but it didn't work. From the Azure documentation, I have found that until V12 of the azure database replication wasn't available. But what about v12?
Questions:Am I missing something with the version of the database? Should I change the database plan in Azure subscription? Should I use some external tool that allow me to maintain sync my database server with the replication?
Upvotes: 3
Views: 700
Reputation: 1293
Replication is not yet available according to the 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 sync logic with change tracking, Service broker and linked servers / safe CLR but better use the existing tools.
Upvotes: 1
Reputation: 106
Maybe Azure Data Factory Service could be a solution for you? https://azure.microsoft.com/en-us/documentation/articles/data-factory-introduction/
Upvotes: 0