Error while importing the bacpac file to dev machine

(1) Share

Report

Posted on by spidey1010

183

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,443 Super User 2025 Season 2 on at

Like (1)

Report

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 183 on at

Like (1)

Report

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,443 Super User 2025 Season 2 on at

Like (1)

Report

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 183 on at

Like (1)

Report

HI Amine,

Got the same error,

Was this reply helpful? Yes No
Suggested answer

Martin Dráb 237,976 Most Valuable Professional on at

Like (1)

Report

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 183 on at

Like (1)

Report

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 237,976 Most Valuable Professional on at

Like (1)

Report

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 183 on at

Like (1)

Report
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

Join the conversation

Community site session details

Error while importing the bacpac file to dev machine

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

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

Featured topics

Product updates

Community site session details

Error while importing the bacpac file to dev machine

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

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

Featured topics

Product updates