Azure / Azure/azure-cli

az sql db import/export should support access token

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

Description

**Describe the solution you'd like**

Currently `az sql db export` and `az sql db import` demand user and password from a database user. It should also support Active Directory Integrated authentication with an access token.

**Describe alternatives you've considered**

Continue using user and password, which is less secure.

**Additional context**

This is currently supported [in sqlcmd with PowerShell and `Invoke-Sqlcmd`](https://docs.microsoft.com/en-us/powershell/module/sqlserver/invoke-sqlcmd?view=sqlserver-ps#example-11--connect-to-azure-sql-database--or-managed-instance--using-an-access-token), and from several Sql Server drivers (see the [example for .NET](https://docs.microsoft.com/en-us/sql/connect/ado-net/sql/azure-active-directory-authentication?view=sql-server-ver15#support-for-a-custom-sql-authentication-provider)).

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.