Azure / Azure/azure-cli

Export SQL database to a local file

Open
#29,716 1 comment 0 reactions 0 assignees View on GitHub
act-codegen-extensibility-squad Auto-Assign customer-reported Service Attention SQL
Dominant language
Python
Stars
4.6k
Forks
3.5k
Avg merge
3d 2h
Merged PRs (30d)
60

Description

**Related command**
az sql db export

**Is your feature request related to a problem? Please describe.**
Need an ability to export database into a local `bacpac` file.

**Describe the solution you'd like**
An option to use the `az sql db export` command with local file support. For instance:
```bash
az sql db export \
--resource-group "..." \
--server "..." \
--name "..." \
--admin-user "..." \
--admin-password "..." \
--file "EXPORT_FILE.bacpac" \
```

**Describe alternatives you've considered**
Current alternative solution is to use the `SqlPackage` tool. For instance:
```bash
sqlpackage /a:Export /tf:"EXPORT_FILE.bacpac" /scs:"DATABASE_CONNECTION"
```

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.