How to move customers from production to sandbox.

(0) Share

Report

Posted on by CU15011641-0

How to move the customers from production environment to sandbox environment?
I already made a configuration package of those customers in production environment and exported it. How can i import them to sandbox environment? if i have to use configuration package, then how?

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (5)

Answers (1)

Suggested answer

Khushbu Rajvi. 22,132 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Go through it: https://yzhums.com/4286/
https://www.youtube.com/watch?v=mLPwollbsSA

Was this reply helpful? Yes No
Suggested answer

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

Like (0)

Report
Copy link

Link copied!

Hi @CU15011641-0,

You need to use the configuration packages tools to export/import the data.

https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/administration/set-up-standard-company-configuration-packages

Best regards,

Mohamed Amine MAHMOUDI

Was this reply helpful? Yes No
Suggested answer

Valentin Castravet 32,214 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hope this helps - How to Import Data Using Configuration Packages in Dynamics 365 Business Central - Dynamics 365 Business Central Insights

Valentin Castravet
Work: Zander ERP Services
Blog: Dynamics 365 Business Central Insights
LinkedIn: www.linkedin.com/in/valentin-c-0500a247/

Was this reply helpful? Yes No
Suggested answer

CU15011641-0 87 on at

Like (0)

Report
Copy link

Link copied!

I am trying to do:

Importing the Customer back up file (excel) from production environment into sandbox environment.

I am doing:

I exported the Customer table (Table 18) from the production environment using a new configuration package and saved it as a backup. Similarly, I exported the Customer table from the sandbox environment (CONTOSO) using a new configuration package and saved it.
I then copied the customer data from the production environment Excel sheet into the sandbox environment Excel sheet and saved the changes. Next, I opened the configuration package in the sandbox environment and imported the updated data. However, upon applying the data (Apply Data), I encountered errors.

Errors i am getting:

The field primary contact no. of table customer contains a value FALSE that cannot be found in the related table (Contact)

I am getting so many of the different errors of the fields.

Can someone please advice me what to do to resolve these errors and get the excel file data from production back into sandbox.

Was this reply helpful? Yes No
Verified answer

Valentin Castravet 32,214 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

You need to fix all the errors in the data. If you don't need the contacts, you can clear out that field in your excel file and then import it again. If you need the contacts, the you'll have to import them as well using configuration packages.

Valentin Castravet
Work: Zander ERP Services
Blog: Dynamics 365 Business Central Insights
LinkedIn: www.linkedin.com/in/valentin-c-0500a247/

Was this reply helpful? Yes No