How To Copy Production Database To New Sandbox Environment In Dynamics 365 Business Central

Published on October 29, 2021

Creating a sandbox environment by copying your production database in Business Central is a vital practice for rigorous testing and development initiatives, safeguarding the integrity of live operational data. However, executing this process demands precision to mitigate potential complications. Our Business Central consulting services furnish expert guidance, ensuring a seamless and error-free replication. This article lists out the essential steps for effectively copying your production database to a sandbox, thereby empowering your organization to conduct thorough testing and development with confidence and minimal risk.

Step 1: Login to Business central environment

Step 2: In the top left corner, click Admin centre àEnvironments

Create New Sandbox Environment

Step 3: Click “New” button to create the new environment

Copying production database to sandbox in business central-1

Step 4: Enter Sandbox name, Type, Region, and enable “create a database for this environment” flag

Copying production database to sandbox in business central-2

We help companies gain more from Business Central.

You will need to wait for some time until this is processed.

Step 5: Once sandbox is created, a message appears as shown below on the environment section of the Admin centre. Follow the steps below for creating a new sandbox environment:

  1. Select production environment and click Copy from the top action ribbon
  2. Copying production database to sandbox in business central-3

  3. Once you click on Copy, you will be asked about the target environment. Choose your created sandbox.
  4. Copying production database to sandbox in business central-4

  5. Provide the environment details and click Copy
  6. Copying production database to sandbox in business central-5

  7. Upon confirmation, the copying process will start.
  8. Copying production database to sandbox in business central-6

  9. Once the database is copied, “The Environment was successfully created” notification will appear.