Replicating on-prem MS SQL databases with Azure DataFactory
0
votes
0
answers
371
views
Is it possible to replicate a database from an on-prem SQL server to a SQL Server running on an Azure VM (SQL on IaaS, **not** a SQL Managed Instance or an AzureSQL database) using Azure DataFactory?
Most of the documentation refers to cloud migration, i.e. from on-prem to AzureSQL.
I'm hoping to use Azure DataFactory, rather than log shipping or distributed AGs, or something more near-realtime than hourly backup/FTP/restore.
Asked by Marcel
(111 rep)
Mar 14, 2022, 12:48 PM