Azure / Azure/azure-cli

az sql copy db to support copy from elastic pool into a single db

Open
#16,264 2 comments 0 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.**
I want to be able to copy a database with elastic pool (from production) to a server where elastic pool doesn't exist (development).

**Describe the solution you'd like**
Ideally I want to provide an sku tier via parameter, so that the destination sku doesn't depend on the source. It works with Azure Powershell as well as the azure portal.

**Describe alternatives you've considered**
Create an elastic pool first, then copy the db there, then move it out of the pool, then delete the pool. A bit cumbersome, isn't it?

**Additional context**
The functionality above is required to script the automatic setup of a feature-branch environment. I want a fresh copy of the prod database on the dev server. The rest of the environment configuration is done via k8s helm chart.

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.