Azure Data Studio - Why Is Restore Option Missing Entirely?
I am doing a simply .bak restore using Azure Data Studio.
Following the instructions available here.
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
Solution
Azure SQL database doesn't support backup from .bak files. Please use .bacpac files instead.
You could ref this feedback:
Update:
As for now, you decided to use management studio on windows to solve the issue.
We can't any document talked about the Data Studio UI difference between Mac and Windows. Turn to use SSMS on windows may be another solution.
HTH.
- How can I manage Azure SQL user/login/credentials
- How to grant a Managed Identity permissions to an Azure SQL Database using IaC?
- No PK or FK when exporting SQL Server database
- Unexpected Recreation and Cost Increase of Deleted SQL Database in Azure: Is it a Bug or an Expected Behavior?
- Create Index without name while creating table
- CXSYNC_PORT wait type in Azure Sql Database
- New Linked Service (Azure SQL Database) Test connection failed
- Query a database inside Azure managed instance from Powershell
- Reduce Azure SQL Database Size
- Unable to reproduce primary key error on 'create if not exists sql'
- Azure AD user unable to connect to Azure SQL Error: 18456,State:1,Class:14
- Azure pipelines cannot connect to Azure SQL via AD/Entra using a custom console application
- .sqlproj building and deployment workflow
- What is the maximum supported compatibility level for EF6?
- Build and Deployment of DACPAC via Azure DevOps Pipeline without .sln (or any artifact)
- Add Azure Active Directory User to Azure SQL Database
- How do I copy SQL Azure database to my local development server?
- Reset identity seed after deleting records in SQL Server
- Why is Azure SQL database so expensive?
- Azure Data Studio - Why Is Restore Option Missing Entirely?
- Azure Granted Permission to SQL Server not authenticating
- Azure SQL database not available on first connection attempt
- In Azure dashboard - give user access to a single App Server, SQL Database, & Azure Storage
- Changing Azure Resource Group location
- Azure SQL backup is not available to restore to a new server
- C# DB project with SqlAzureV12DatabaseSchemaProvider: add filegroup is not possible?
- Azure Data Factory: How to use Exists when the source(Blob - csv) and target (SQL DB) are massive datasets (different datatypes ~370 cols, ~7M rows)
- SQL Azure - Create External Data Source: Location as a Parameter?
- Azure SQL Server Firewall Rule add multiple IP address using PowerShell for database connectivity
- Calling a stored procedure from EF Core 8 with Managed Identities