0

I have a database hosted on Azure and I have connected to it from mac machine using Azure Data studio. I want to take a backup of this database and then restore it in localhost to access it locally for better speed during development. I don't see any option to backup and restore the Azure database using Azure Data Studio. there were several options available in SQL server management studio on windows.

Suggestions, please.

jarlh
  • 42,561
  • 8
  • 45
  • 63
Asif Hameed
  • 1,353
  • 9
  • 25
  • 46
  • 2
    Assuming it's an Azure SQL Database you can't use the `RESTORE` and `BACKUP` methods, you needs to use a bacpac or dacpac. – Thom A Oct 15 '21 at 13:19
  • 2
    See [SQL Server dacpac extension](https://learn.microsoft.com/en-us/sql/azure-data-studio/extensions/sql-server-dacpac-extension?view=sql-server-ver15) – Thom A Oct 15 '21 at 13:21

1 Answers1

1

As stated by Larnu, yes that could be possible using DACPAC and BACPAC in Azure.

SQL Server DACPAC extension – Here.

The wizard facilitates the creation and deployment of data-tier pieces that support your application by making it easier to manage dacpac and bacpac files. Check out MSFT documentation to learn more about utilising Data-tier apps, here.

A DAC is a self-contained SQL Server database deployment unit that allows data-tier developers and database administrators to package SQL Server objects into a portable artefact known as a DAC package, sometimes referred to as a DACPAC. A BACPAC is a similar artefact that contains both the database schema and the data contained in it.

IpsitaDash-MT
  • 1,326
  • 1
  • 3
  • 7