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

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

As the process get completed use SysTools SQL Server to Azure Migrator to migrate .mdf files to Azure Database.