How to restore SQL Server bak file to Azure SQL Database

0 votes
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..
Jul 4, 2018 in Azure by null_void
• 3,220 points
32,886 views

2 answers to this question.

0 votes

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!!

answered Jul 4, 2018 by club_seesharp
• 3,450 points
0 votes

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. 

answered May 28, 2019 by sherry
• 140 points

Related Questions In Azure

+1 vote
1 answer

How to copy Azure SQL database to a local development server?

Actually, there are multiple ways to do ...READ MORE

answered Jul 9, 2018 in Azure by null_void
• 3,220 points
2,360 views
0 votes
1 answer

How can I copy SQL Azure database to a local development server?

There are certain ways to do this: Using SSIS ...READ MORE

answered Jun 26, 2018 in Azure by null_void
• 3,220 points
967 views
0 votes
1 answer

How to query between databases in SQL Azure Database Server?

SQL Azure supports cross database queries: https://azure.microsoft.com/en-us/blog/querying-remote-databases-in-azure-sql-db/ Hope this ...READ MORE

answered Apr 9, 2019 in Azure by Prerna
• 1,960 points
12,282 views
0 votes
1 answer

How to calculate the used database space in SQL Azure?

I don't think its possible to find ...READ MORE

answered Mar 5, 2019 in Azure by Archana
• 5,640 points
908 views
0 votes
1 answer

SQL Azure Database: Unable to restore bacpac due to foreign key conflict.

Since tha bacpac file is not transactional, ...READ MORE

answered Apr 2, 2019 in Azure by Prerna
• 1,960 points
2,527 views
0 votes
1 answer

How do disconnect to Azure SQL database if I can't access it?

Based on info  from Microsoft, I think ...READ MORE

answered Apr 26, 2019 in Azure by Prerna
• 1,960 points
1,022 views
0 votes
1 answer

What is Azure SQL database? How to connect to Azure SQL database?

Azure SQL Database is a general-purpose relational ...READ MORE

answered Jan 13, 2020 in Azure by Sirajul
• 59,230 points
1,243 views
+1 vote
1 answer

How to backup Azure SQL Database?

In Azure SQL Database, you can configure ...READ MORE

answered Jan 22, 2020 in Azure by Sirajul
• 59,230 points
22,838 views
0 votes
1 answer

How can we connect Azure Web App to an Azure SQL Database?

Its easy now! Go to your Azure SQL ...READ MORE

answered Aug 9, 2018 in Azure by club_seesharp
• 3,450 points
6,496 views
0 votes
1 answer

How to upload a file on to Azure Blob storage without writing a code?

You can find the below tools useful ...READ MORE

answered Apr 13, 2018 in Azure by club_seesharp
• 3,450 points
1,244 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP