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

Notifications

Announcements

Season of Giving Solutions is Here!
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

News and Announcements

Season of Giving Solutions is Here!

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the December Top 10 Community Leaders!

These are the community rock stars!

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

#1
Abhilash Warrier Profile Picture

Abhilash Warrier 843 Super User 2025 Season 2

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 423 Super User 2025 Season 2

#3
Martin Dráb Profile Picture

Martin Dráb 342 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans