search

Azure-Samples / data-migration-sql

This is a repository of script samples to migrate SQL Server databases to Azure using Azure Database Migration Service
MIT License
21 stars 17 forks source link

Support "Active Directory Password" authentication method for TargetSqlConnectionAuthentication #8

Open shawnz88 opened 7 months ago

shawnz88 commented 7 months ago

Please provide us with the following information:

This issue is for a: (mark with an x)

- [ ] bug report -> please search issues before submitting
- [x ] feature request
- [ ] documentation issue or request
- [ ] regression (a behavior that used to work and stopped in a new release)

Minimal steps to reproduce

For "SQL Server to Azure SQL Database" with Powershell, TargetSqlConnectionAuthentication currently only supports two types: The authentication type for connection, which can be either SqlAuthentication or WindowsAuthentication.

Can it be extended to support "Active Directory Password" or managed identity?

Any log messages given by the failure

Expected/desired behavior

"Active Directory Password" or managed identity authentication methods are supported.

OS and Version?

Windows 7, 8 or 10. Linux (which distribution). macOS (Yosemite? El Capitan? Sierra?)

Versions

Mention any other details that might be useful

Thanks! We'll be in touch soon.

sanfordn commented 7 months ago

Interested in seeing the outcome here. I could use this as well