First published on MSDN on Jan 09, 2017
We received a multiple times the question about if is it possible to upload a SQL server backup (.bak) to an Azure database? and our answer is not, right now. However, you have a multiple options that allows you to import the database from SQL Server OnPremise to Azure SQL Database, you could find the answer in this
Related to this one, our customers asked about once we have our database in Azure SQL Database if is it possible to migrate an Azure database to an on premise server?, our answer is yes:
You need to export the data to a BACPAC file using this
, even, you could use other tools like these ones:
To import the data from a BACPAC file you could use:
Instead of exporting/importing every time, if you need to maintain the data synchronized, also, you could use
from SQL Server OnPremise/IaaS to Azure SQL Database.