How to restore SQL Server bak file to Azure SQL Database

Question

Can anyone here show me a way to simply take a SQL backup .bak file, and using that as a restore 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...

I do not have the script files to decrypt the objects. I inherited this mess..

Answer 1

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

Hope this helps!!

To know more about Azure, enroll today with our Azure certification course.

Thanks!!

Answer 2

To restore SQL Server .bak file you can go through this simple blog https://www.systoolsgroup.com/how-to/restore-mdf-file-from-backup/ here complete step by step process is decribed to restore .mdf files. As the process get completed use SysTools SQL Server to Azure Migrator to migrate .mdf files to Azure Database.