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.

Welcome to Intellipaat Community. Get your technical queries answered by top developers!

30.4k questions

32.5k answers

500 comments

108k users

Browse Categories

...