Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Azure SQL Server restore using .bak file

I have created a SQL Server in Azure and have downloaded the Azure Data Studio. I have a SQL Server database backup file (.bak) and connected to the sever that I created from Azure Data Studio and I am not seeing an option to restore the database.

I just have the back up file available and don't have any on perm database available and I want to directly restore the database to the Azure SQL Server.

like image 962
karas27 Avatar asked Sep 16 '26 10:09

karas27


1 Answers

Azure SQL database currently does not support this feature. The only way to restore a SQL database in Azure is to import from a BACPAC file as @Larnu said. You can follow this guide to use a BACPAC file to migrate to an Azure SQL database.

Another option:
If you get an account to connect to the local server.You can use SQL Management Studio to migrate it directly to Azure.
enter image description here

like image 144
Joseph Xu Avatar answered Sep 19 '26 02:09

Joseph Xu



Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!