How do I back up a SQL database to Azure from Microsoft SQL Server Management Studio

Question

I don't have access to the Azure portal to do it from that instance. I need to migrate the database to another server

Answer 1

Hi @Sergio Sanchez

I'm assuming you want .bacpac file of a Azure SQL DB. Follow below steps.

1. If you have SSMS installed in your machine, connect to database using ssms, use the server credentials or get access to take backup.
2. Go to database, right click -> Task ->Export Data tier application
3. Select storage account, container and file name, or you can export to your local and click next and then Export.
4. 

Once the file exported, you can import the same to another server

Hope this help!

Thank You!

Answer 2

Hi @Sergio Sanchez

If you already have a database on local machine then you can migrate it directly on Azure using SQL Management Studio. Follow these steps:

Right click on the database name in SSMS:

Regards，

Zoe Hui

---

If the answer is helpful, please click "Accept Answer" and upvote it.