Intellipaat Back

Explore Courses Blog Tutorials Interview Questions
0 votes
2 views
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.

31k questions

32.8k answers

501 comments

693 users

Browse Categories

...