Skip to main content

Notifications

Finance | Project Operations, Human Resources, ...
Answered

Import the database

(0) ShareShare
ReportReport
Posted on by 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?

  • 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,330 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

Quick Links

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Congratulations to the January Top 10 leaders!

Check out the January community rock stars...

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,160 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,962 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans