Error while importing the bacpac file to dev machine

(1) Share

Report

Posted on by spidey1010

201

Hi ,

I exported the bacpac file from LCS and tried this command while importing - SqlPackage.exe /a:import /sf:C:\Users\Admin195bb577ec\Downloads\UAT.bacpac /tsn:localhost /tdn:AXDBUAT /p:CommandTimeout=1200 /TargetEncryptConnection:False

Please suggest how to move further. Tried editing the model file but afterward how to procced, i am confused.

I have the same question (0)

All responses (8)

Answers (1)

Suggested answer

Mohamed Amine Mahmoudi 26,801 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hi,

Try this :

1. Open the .bacpac file using WinRar

2. Copy the model.xml to a local folder “C:\Temp\model.xml”

3. Edit the “C:\Temp\model.xml” with the desired password. For example:

find <Property Name="AutoDrop" Value="True" /> and Delete

4. Run the import using sqlpackage.exe, but use the /ModelFilePath:C:\Temp\model.xml parameter to override the model.xml in the .bacpac file

Best regards,

Mohamed Amine MAHMOUDI

Was this reply helpful? Yes No
spidey1010 201 on at

Like (1)

Report
Copy link

Link copied!

HI,

I saw that reply on other thread. As i told u, i have edited the model file but cant proceed further like where should i use model file path in my command ?

Was this reply helpful? Yes No
Suggested answer

Mohamed Amine Mahmoudi 26,801 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hi,

you can use this :

SqlPackage.exe /a:import /sf:C:\Users\Admin195bb577ec\Downloads\UAT.bacpac /tsn:localhost /tdn:AXDBUAT
/ModelFilePath:C:\Users\Admin195bb577ec\Downloads\model.xml

Best regards,

Mohamed Amine Mahmoudi

Was this reply helpful? Yes No
spidey1010 201 on at

Like (1)

Report
Copy link

Link copied!

HI Amine,

Got the same error,

Was this reply helpful? Yes No
Suggested answer

Martin Dráb 239,040 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

This is caused by a property added in a newer version of SQL Server than what you're using locally. You can remove it from the bacpac file with Repair-D365BacpacModelFile from d365fo.tools.

Was this reply helpful? Yes No
spidey1010 201 on at

Like (1)

Report
Copy link

Link copied!

HI Martin,

Tried executing this

Repair-D365BacpacModelFile -Path C:\Temp\Base.xml -KeepFiles -Force

But it says that it cannot recognise the Repair-D365BacpacModelFile as a command.

Was this reply helpful? Yes No
Martin Dráb 239,040 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

It means that you didn't install the Powershell module d365fo.tools correctly (or at all).

Was this reply helpful? Yes No
Verified answer

spidey1010 201 on at

Like (1)

Report
Copy link

Link copied!
This helped me resolving the issue -

Go to sql package folder.

Open the power shell via admin.

Run this command -

PS C:\Users\Admin195bb577ec\Downloads\sqlpackage-win-x64-en-162.4.92.3> .\SqlPackage.exe /a:import /sf:"I:\UAT.bacpac" /tsn:localhost /tu:axdbadmin /tp: ‘AX SQL password’ /tdn:AXDBUAT /p:CommandTimeout=1200 /p:DatabaseEdition=Premium /p:DatabaseServiceObjective=P1 /ttsc:true

Replace AX SQL password with your sql password taken form LCS.

Was this reply helpful? Yes No