Import bacpac to Dev environment

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:

Leave a Comment