Skip to main content

Notifications

Small and medium business | Business Central, N...
Answered

How to move customers from production to sandbox.

(0) ShareShare
ReportReport
Posted on by 59
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?
  • Verified answer
    Valentin Castravet Profile Picture
    Valentin Castravet 25,785 Super User 2025 Season 1 on at
    How to move customers from production to sandbox.
    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. 
     
  • Suggested answer
    CU15011641-0 Profile Picture
    CU15011641-0 59 on at
    How to move customers from production to sandbox.
    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.
  • Suggested answer
    Valentin Castravet Profile Picture
    Valentin Castravet 25,785 Super User 2025 Season 1 on at
  • Suggested answer
    Mohamed Amine Mahmoudi Profile Picture
    Mohamed Amine Mahmoudi 13,896 Super User 2025 Season 1 on at
    How to move customers from production to sandbox.
     
    You need to use the configuration packages tools to export/import the data.
     
     
    Best regards,
    Mohamed Amine MAHMOUDI
  • Suggested answer
    Khushbu Rajvi. Profile Picture
    Khushbu Rajvi. 7,919 Super User 2025 Season 1 on at
    How to move customers from production to sandbox.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Congratulations to the January Top 10 leaders!

Check out the January community rock stars...

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,074 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,900 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans