Azure / Azure/azure-cli

Add support for restoring managed instance databases to instances in another region

Open
#16,937 2 comments 2 reactions 0 assignees View on GitHub
act-codegen-extensibility-squad Service Attention SQL
Dominant language
Python
Stars
4.6k
Forks
3.5k
Avg merge
3d 2h
Merged PRs (30d)
60

Description

**Is your feature request related to a problem? Please describe.**

The current [api](https://docs.microsoft.com/en-us/rest/api/sql/manageddatabases/createorupdate) will return `SubscriptionDoesNotHaveServer` if the source and destination database are not in the same location.

It is actually possible to do such a thing in the UI.
Go to the target instance -> New database -> Use existing data (Backup) and choose a database from a different region.

**Describe the solution you'd like**
Since it is possible with some other api call via the portal, the cli should be able to do it as well.

**Describe alternatives you've considered**
Don't know much of the internals here to suggest something.

**Additional context**
I have not tried it with PowerShell.

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.