Azure Data Studio - Why Is Restore Option Missing Entirely?

Question

I am doing a simply .bak restore using Azure Data Studio.

Following the instructions available here.

https://learn.microsoft.com/en-us/sql/samples/adventureworks-install-configure?view=sql-server-ver15&tabs=data-studio#tabpanel_1_data-studio

However, on my Mac, I dont get that option at all.

I dont understand. is the backup option facility not available in Azure Studio anymore?

Note:

Azure Data Studio details.

Version: 1.27.0
Commit: 765c7064d46253d88393e0e1ff78874b6fe8fa64
Date: 2021-03-16T21:18:54.187Z
VS Code: 1.51.0
Electron: 9.4.3
Chrome: 83.0.4103.122
Node.js: 12.14.1
V8: 8.3.110.13-electron.0
OS: Darwin x64 20.2.0

Answer 1

I got the same issue on my Mac. When i connect to the local database server (without selecting a database) i get the option to export / import by right clicking the database name. This however don't work when connecting to an Azure Database server

A workaround is to install the "SQL Server Dacpac" extension from Microsoft from the marketplace inside Azure Data Studio. Then you can export and import from bacpac files using the Data-tire Application Wizard

Answer 2

The restore option is available as a Preview Feature. You can enable this from Settings -> Workbench: Enable Preview Features. Once enabled, right click on the Databases from the connected Server you can now see the Restore Database(preview) option. I could successfully restore from a backup file.