March 21, 2019 at 2:40 pm
We have some Azure IaaS (on prem) SQL database instances running.
We would like to use an Azure SQL database (not IaaS, just the Azure SQL database that we pay for by size and everything else is handled, no management, no instance, etc) as a destination for reporting.
Our goal would be that we take our IaaS VMs that are in an Always On synchronous availability group and add a 3rd read only "copy" in Azure SQL.
That 3rd copy need not be synchronous, it just needs to have a fully copy of the data sent up to it...somewhat within the last 15 minutes.
What is the best way to use Azure SQL as a read only copy of existing IaaS VMs running SQL Server in an always on availability group?
Thanks!
I looked at this, however, it appears it only supports using a source that is an existing SQL Azure database (not a VM running SQL Server) https://docs.microsoft.com/en-us/azure/sql-database/sql-database-read-scale-out
March 25, 2019 at 12:59 am
You cannot use an Azure SQL Database (PaaS) as a secondary in an Always On architecture, however, you can use it as a replication subscriber. You could replicate from your on-premises Always On group to an Azure SQL Database and use that for reporting.
This also allows you to leverage some of the features of replication, such as only replicating the tables required for reporting, different indexing strategies on your reporting database etc.
April 5, 2019 at 11:28 am
If you just need the data to be pushed up to an Azure SQL Database instance, I think you may be able to use Data Sync and set the Sync to pull on a schedule, like every 5 minutes or something. Granted there are factors you’ll need to consider such as do any of my tables have user defined data types (if so, those columns cannot be synced), the size of the data base etc.
You'd install a sync agent, provide a token and then register the database you’d like to have synced with Azure.
April 12, 2019 at 6:44 pm
This was removed by the editor as SPAM
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply