Import (.bacpac) file to the Sandbox (UAT) environment

(4) Share

Report

Posted on by Syed Amir Ali

205

Hi Experts,

I have two questions. First, I want to import an AxDB (.bacpac) file into the UAT environment. I understand that the file needs to be uploaded under Database backup in the Asset Library in LCS, but I’m not sure which backup type is appropriate. Based on my understanding, the Product database option seems to be the correct choice for uploading a .bacpac file. Please advise which backup type should be selected.

Second, I believe that only a .bacpac file of up to 30 GB or a .bak file of 14.3 GB can be uploaded. If we need to upload a database larger than these limits, then a support ticket must be raised to Microsoft to temporarily increase the size limit.

Please note that, In this case we need to upload the database from the cloud-hosted development environment to the UAT environment.

Thanks in advance.
Amir.

Categories:

Dynamics 365 Finance

Microsoft Dynamics AX

I have the same question (0)

All responses (7)

Answers (1)

Sort by

Suggested answer

Sohaib Cheema 49,679 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi,

1) you can directly go on a sandbox( on LCS) and choose Maintain >> Move Database >> Refresh Database

Choose any source (could be production system, or any other systems, excluding CH Devs)

You do not need to save the backup file anywhere to refresh the database.

2) The limit is 50 GB

Was this reply helpful? Yes No
Syed Amir Ali 205 on at

Like (0)

Report
Copy link

Link copied!

Hi @Sohaib Cheema,

Thank you for your reply.

Actually, in my case we need to upload the database from the cloud-hosted development environment to the UAT environment.

Was this reply helpful? Yes No
Sohaib Cheema 49,679 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi,

Yes, in such cases, you may need to place the database on the LCS Asset Library, where you will meet the limit of 14.3 GB for the file size

Was this reply helpful? Yes No
Sagar121 1,190 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hi @Syed Amir Ali,

I have always used Product Database( SQL server .bak). It didn't give me any issues ever.

Was this reply helpful? Yes No
Syed Amir Ali 205 on at

Like (0)

Report
Copy link

Link copied!

Hi @Sohaib Cheema,

I already included your suggestion about the 14.3 GB (.bak) database size in my original query. Please read my statement again to understand what information I actually need.

Was this reply helpful? Yes No
Verified answer

Sohaib Cheema 49,679 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hi,

The two choices you see there:

1st one is for financial reporter (also known as Management Reporter, previously).

2nd one is for D365 FO system (Operational Database)

Ignore the 1st option.

Was this reply helpful? Yes No
Syed Amir Ali 205 on at

Like (0)

Report
Copy link

Link copied!

Thank you @Sohaib Cheema for your suggestion,

Yes, I have already selected the second backup type option labeled ‘Product database (SQL Server or .bak)’. The first option is ‘Financial reporting database (.bak)’. I am uploading my (.bacpac) file to the Asset Library under the Database Backup tab.

Was this reply helpful? Yes No