web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Import the database
Finance | Project Operations, Human Resources, ...
Answered

Import the database

(0) ShareShare
ReportReport
Posted on by AstridMalanka 8

Hi,

I am trying to import a database, but I am getting this weird erros, that incorrect syntax near type and cannot create an user.

We have recently install the new version on that test environment and this is a backup from over a month ago.

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....

any ideas why?

I have the same question (0)
  • Verified answer
    Gunjan Bhattachayya Profile Picture
    Gunjan Bhattachayya 35,423 on at

    Hi Astrid,

    You need this version of sqlpakage.exe. unzip this file and try running the import command.

    It should work

  • Suggested answer
    vinitgoyal2005 Profile Picture
    vinitgoyal2005 6,332 on at

    Hi,

    Are you following docs.microsoft.com/.../dbmovement-scenario-exportuat

    If not please follow it for import. Also the warning about "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" is ok. That is correct, you don't have to worry about it. Import will still happen. Make sure you run the script mentioned in the above link after import of the data.

    For error whck link community.dynamics.com/.../import-bacpac-file-exported-from-uat-to-devops---create-user-syntax-error  and

    ramblingsofraju.com/.../

  • AstridMalanka Profile Picture
    AstridMalanka 8 on at

    Thanks for the replies, I just needed a newer version of sqlpakage.exe

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the February Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 514 Super User 2026 Season 1

#2
Giorgio Bonacorsi Profile Picture

Giorgio Bonacorsi 390

#3
Adis Profile Picture

Adis 266 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans