Finance | Project Operations, Human Resources, ...

Which command is correct to import the .bacpac file - D365FO

(0) Share

Report

Posted on by Akbarpasha

Hi All,

We are trying to refresh DEV database with UAT, and exported the UAT database,

Found few links for importing the .bacpac file:

commands:

Cd C:\Program Files (x86)\Microsoft SQL Server\140\DAC\bin

SqlPackage.exe /a:import /sf:C:\Temp\hsauatbackup.bacpac /tsn:localhost /tdn:AxDb_6 /p:CommandTimeout=1200

but in our dev machine we didn't find the path "C:\Program Files (x86)\Microsoft SQL Server\140\DAC\bin" in C drive,

we are using below command:

C:\Program Files (x86)\Microsoft Visual Studio\2017\Professional\Common7\IDE\Extensions\Microsoft\SQLDB\DAC\150

Is it correct way to import or do we need to use the first command which does not exists in our dev machine.

Please advise us.

Regards,

Akbar

I have the same question (0)

All responses (4)

Answers (0)

Sort by

Suggested answer

nunomaia 27 Moderator on at

Like (0)

Report
Copy link

Link copied!

You can use the version of sqlpackage that you have in your machine, it is a SQL Server utility.

You can also download the latest version from Download and install sqlpackage - SQL Server | Microsoft Docs

Was this reply helpful? Yes No
Akbarpasha on at

Like (0)

Report
Copy link

Link copied!

Hi Nuno,

Thanks for the quick response,

can we use the below path to import db file:

C:\Program Files (x86)\Microsoft Visual Studio\2017\Professional\Common7\IDE\Extensions\Microsoft\SQLDB\DAC\150

Was this reply helpful? Yes No
Suggested answer

nunomaia 27 Moderator on at

Like (0)

Report
Copy link

Link copied!

The sqlpackage version that you point should be a 18.4. I had some issues with that version and I upgraded to a newer version. You can still use that version, it should be fine.

It's not mandatory to upgrade only if you have problems while importing.

Was this reply helpful? Yes No
Suggested answer

Pranitha Nidumolu Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hello Akbar,

I believe, these two MS Docs will be of help for you. If you already have SSMS on your DEV machine, better go with - Import a BACPAC file to create a new user database - SQL Server | Microsoft Docs

If you would like to use Azure portal to the same you can use - Import a BACPAC file to create a database in Azure SQL Database - Azure SQL Database | Microsoft Docs

Thanks,

Pranitha

Was this reply helpful? Yes No