web
You’re offline. This is a read only version of the page.
close
Skip to main content
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)
  • AstridMalanka Profile Picture
    AstridMalanka 8 on at
    RE: Import the database

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

  • Suggested answer
    vinitgoyal2005 Profile Picture
    vinitgoyal2005 6,332 on at
    RE: Import the database

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

  • Verified answer
    Gunjan Bhattachayya Profile Picture
    Gunjan Bhattachayya 35,421 on at
    RE: Import the database

    Hi Astrid,

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

    It should work

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

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft
Our Community Code of Conduct has been updated!

Quick Links

Responsible AI policies

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

Andrés Arias – Community Spotlight

We are honored to recognize Andrés Arias as our Community Spotlight honoree for…

Congratulations to the August Top 10 Community Leaders!

These are the community rock stars!

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

#1
CA Neeraj Kumar Profile Picture

CA Neeraj Kumar 846

#2
André Arnaud de Calavon Profile Picture

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

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 797 User Group Leader

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans