Explore Courses Blog Tutorials Interview Questions
0 votes
in Azure by (12.7k points)

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.

1 Answer

0 votes
by (9.6k points)

It is possible to do so using bacpac file that is in your on-premise and migrate it to create a new database in Azure SQL Database. 

You can also use SSMS for doing so. More information is here.

See this article for information.

Browse Categories