Database Project Extension in WSL2 CreatesObjects that Break in Windows

[nathanweil]

• Azure Data Studio Version: None
• VSCode Version: 1.98.2
• SQL Database Project Extension Version: 1.4.6
• OS Version: Windows 11 26100.3476

Steps to Reproduce:

1. Open VSCode
2. Open a Repository in WSL2 using the WSL extension
3. Navigate to SQL Database Project view
4. Click on the ellipses and choose "Create Project From Database"
5. Navigate to the Server, choose the Database (with AD logins), and the destination
6. Choose "Schema/Object Type"
7. Choose "Yes" for Include Permissions
8. Choose "Yes" for SDK-style project
9. Commit and Push the changes to origin
10. Open the same repo from Windows, not WSL2
11. Attempt to Pull from origin
12. Errors returned due to the use of "" in the directory and filenames created in the database project preventing the Pull from completing successfully

Does this issue occur when all extensions are disabled?: No - This bug is in the SQL Database Project extension

This is the issue page for the SQL Database Project extension

The issue is that when creating a database with the SQL Database Project extension creates both hierarchies and filenames with the "" in the names. This works fine in WSL2, Linux, and macOS, but is a breaking bug for Windows. This is an issue for developers in cross-platform environments, or even users that leverage WSL2 vs ones that don't.

The extension should not create directories or filenames with the "" in the names, even though this is the standard for AD accounts in Windows (domain\user). When performing this same action using the same extension but saving the output to a Windows directory, the "" are replaced with a "_", which prevents this breaking issue.

The extensions should be creating objects in a standard way that works across all platforms instead of creating objects that are incompatible. I should not need to run scripts after the process creates the objects to fix the naming convention.