az sql copy db to support copy from elastic pool into a single db
- 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
Assessment
This issue has not been assessed yet.