Menu
Is there a way to simply take a SQL backup .bak file, and using that as a restore point to generate a new database on Azure SQL Database?
The wizard that I see generally recommended in this situation wants to create a custom file to use, but it pukes on the encrypted objects ( functions and views ) and I don't see another way to get it going.
824
Currently Azure doesn't support restoring the database on Azure SQL Instance using the backup (. bak) file. But there are many other ways to migrate the SQL Database to Azure SQL. For example, using the SQL Server Management Studio deploy mention or by taking the backup in the .
bak file that is in an Azure File Share, attach that File Share to an Azure Container Instance running SQL Server, restore the . bak, create the . bacpac, copy it to Azure Blob Storage, and then import it into an Azure SQL Database.
If you already have a database on local machine then you can migrate it directly on Azure using SQL Management Studio. Follow these steps:
Right click on the database name in SSMS: 
Follow the wizard that appears then.
If you're running SSMS v17 you can configure the Azure SQL database edition, size and service objective.
149
Azure SQL Database does not currently support that functionality. The only method to restore in Azure SQL Database is import from BACPAC files - you can migrate to Azure SQL DB using BACPAC files by following this guide: https://azure.microsoft.com/en-us/documentation/articles/sql-database-cloud-migrate/
The other options is to use SQL Server in a VM, which would enable a restore of a .bak file
28
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
