When you try to import a bacpac file from your UAT environment to your dev environment with the SqlPackage.exe command, the following error came up:
*** Error importing database:Could not import package.
Warning SQL0: The source contains users that rely on an external authentication provider that is not supported by the target. These users will be treated as users without logins.
Error SQL72014: Core Microsoft SqlClient Data Provider: Msg 102, Level 16, State 30, Line 1 Incorrect syntax near ‘type’.
Error SQL72045: Script execution error. The executed script:
CREATE USER [d365-ops-dbms-prod]
Solution: Simply use another version of .NET Core SQLPackage: