SQL Server 2012 log shipping to Azure SQL

All we need is an easy explanation of the problem, so here it is.

Is there any way to take SQL Server 2012 log shipping files and upload them into Azure SQL Database. We just need the data changes and not to bothered about the recovery side of things.

How to solve :

I know you bored from this bug, So we are here to help you! Take a deep breath and look at the explanation of your problem. We have many solutions to this problem, But we recommend you to use the first method because it is tested & true method that will 100% work for you.

Method 1

No, you cannot log ship to an Azure SQL Database, however, there are other options for getting the data up there incrementally. I’ve summarised them below (with links) and all of these support SQL Server 2012 and higher. You need to read through the documentation for each and decide which best suits your requirements.

Replication:
You can configure an Azure SQL Database as a subscriber for Transactional or Snapshot replication. This allows you to have data updated in your Azure SQL Database from an on-premise SQL Server or IaaS SQL Server VM in Azure.

Azure SQL Data Sync:
SQL Data Sync is a utility used to synchronise data bi-directionally between Azure SQL Databases and on-premise/IaaS SQL Server instances. You can use it to distribute data between multiple Azure SQL Databases and is often used when an application’s database is actually sharded across multiple Azure SQL Databases. NOTE: Does not work with Managed Instances at this stage.

Azure Data Factory:
You can leverage Azure Data Factory to move data from your on-premise/IaaS instances up to Azure SQL Databases. This works sort of like an SSIS PaaS solution so doesn’t require additional infrastructure.

SSIS:
You can create packages in SQL Server Integration Services to copy data from your on-premise or IaaS instance up to Azure SQL Database. This process can be scheduled via a SQL Server Agent job to keep data in sync.

Method 2

Straight answer would be ‘No’. You cannot run restore commands on Azure sql. Only way is bacpac .

Note: Use and implement method 1 because this method fully tested our system.
Thank you 🙂

All methods was sourced from stackoverflow.com or stackexchange.com, is licensed under cc by-sa 2.5, cc by-sa 3.0 and cc by-sa 4.0

Leave a Reply