SqlPackage - option to skip Windows logins
Open
Nobody has claimed this yet.
enhancement
- Dominant language
- C#
- Stars
- 460
- Forks
- 29
- Avg merge
- 4d 9h
- Merged PRs (30d)
- 7
Description
- SqlPackage or DacFx Version: 162.2.60.1
- .NET Framework (Windows-only) or .NET Core: .Net 8
- Environment (local platform and source/target platforms): Windows Server 2022
Steps to Reproduce:
- Connect Sql Server to Azure Arc
- Try to export a bacpac
- Get the following result:
One or more unsupported elements were found in the schema used as part of a data package.
Error SQL71627: The element User: [NT AUTHORITY\SYSTEM] has property AuthenticationType set to a value that is not supported in Microsoft Azure SQL Database v12.
Error SQL71627: The element Login: [NT AUTHORITY\SYSTEM] has property IsMappedToWindowsLogin set to a value that is not supported in Microsoft Azure SQL Database v12.
Did this occur in prior versions? If not - which version(s) did it work in?
(DacFx/SqlPackage/SSMS/Azure Data Studio)
Contributor guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
Start with the SqlPackage export command and reproduce the Azure Arc to bacpac failure described in the issue. Trace where SQL71627 is reported for Windows users and logins, then define the option's behavior for skipping them. Done means the export can omit those unsupported elements without the reported errors.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- csharp, sql
- Domain
- databases
- Issue type
- Feature
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Quiet
- Clarity
- Mostly clear
- Newbie friendliness
- 42/100