Get in the Sandbox

   Words by Paul McQuillan

   on 21/10/2019 16:00:00

imageSo you’ve started using Dynamics CRM, got stuck in, set up all your customisations, fields and forms, and started using your system in live across the business – then great, the hard part is over!

But – what happens when you want to make changes, or conduct Training outside of your live environment.

For this, you need a Sandbox Environment.

Which is not normally a problem, as every Instance of Dynamics 365 comes with your own Sandbox Environment that you can use Changes, Training and any other Testing.

The problem often occurred where we needed to take the Customisations built in Live and pass back into Sandbox.

Previously this could be quite touch, particularly if the Customisations were outside a nicely package solution, or were dependent on a number of Apps or Managed Solutions used as the foundation of how you use CRM.

This could also be doubly difficult if your Customisations depended on Data in CRM to really work well – as you would then need to take both the Customisations and the Data back from Live and into Sandbox, as this could be tricky outside the On-Premise world of SQL Backup and Restore.

NOTE: Taking Personal Data from Live to Sandbox may have implications on GDPR Compliance – so this can be an area to tread lightly.

Thankfully the Power Platform has liberated the ability to Backup, Copy and Restore Environments within the Microsoft Cloud – and made this even easier than it was On-Premise.

So we can take our version of Live and passback to our Sandbox Environment in a couple of easy clicks from the Power Platform Admin Centre.

We can open our list of Environments, highlight our Live environment as the ‘source’, and then copy into UAT as the destination:


This will then give options for how we want this Copy to take place – notably on whether we want Everything (Application + Data) or just the Application without Data


In our scenario of having built directly into Production to get Dynamics Live in the business, and now looking to passback into a Test Environment, our best approach would be to opt for Customisations Only to keep our new Test Environment blank.

In other incidences, we might want a fully populated Training Environment and so opt to take both the Data and the Customisations into our Test Environment. (as this will include static data such as Product Catalogues)

Be careful before clicking Copy and double-check you have got your environments the right way round (as there will be no do-overs!), but we can then let the process run through:


Once done, this will show all 4 areas complete – and we are ready to use our new Sandbox.

When the Environment has finished copying over, this will be running in Administration Mode to keep the new Environment in a protected status of being only available to Admins until given the go ahead for more general use.


We can click SETTINGS in this warning prompt to then deactivate Administration Mode.

With this done, we have a copy of Live ready for our Test, Train or Development purposes – this keeps us in line with good best practise, and is particularly key for good Change Management whilst running Dynamics 365.


So we have a nice new empty Sandbox to start using experimenting or training with.

The following mini-site within Microsoft Docs is a good guide on the Administrator Area for the Power Platform and Dynamics 365, explaining various areas of the area in more detail:

What to do next?  Generally any use of Dynamics will want to have a controlled release cycle of new changes, process updates and other functionality from Sandbox to Live.

This can be managed internally by Citizen Developers, or by a Partner such as CRMCS.

The key element is balancing the need for agile change vs consistency in how the system works and is tested for the end users in your organisations – and then balancing the new features and changes that might bring innovation against the established ‘what-works’ already.  This innovation coming from both the Release Cycle from Microsoft + the Release Cycle internally for system customisation from Sandbox to Live. (not to mention Apps and functionality enhancements from the wider marketplace!)

So whilst having a Sandbox and copying over from Live is simple in the Cloud, the use of that Sandbox for delivering regular Change is the real key element in this process.

Share this Article

Search Articles

Filter Articles

CRM Tech DocMan

Recent Articles

HOW TO: Manage Your Dynamics 365 Database Size (Video Included) Dynamics 365 Marketing vs ClickDimensions It’s time to pause, reflect and acknowledge a new era of inclusivity and collaboration. Part 2 - How to get the most from a Technology Expert – Asset Management Hub Property & Asset Management Hub Part 1 – Balancing CRM and Asset Management Scopes - Asset Management Hub Creating a Multi-Lingual PowerApps Portal How to Set Up a Microsoft Teams Site Using DocDrive365 Microsoft Teams - Adding a Microsoft Teams URL to a Dynamics Appointment Dynamics 365 Marketing – Customer Voice Survey Not Appearing In Emails? Using SQL Management Studio to connect to the Dynamics DB Calling a Power Platform AI Builder Model via oData How to use DocDrive365 to integrate permissions between Business Units in Dynamics with Sites in SharePoint Getting started with the Power Platform AI Builder. Power Apps Portal Information Hub DocDrive365 Security: Day One - Getting Started with Dynamics to SharePoint Permissions Part 5 - Power Apps Portals: How To Connect Azure B2C With Linked-In Part 4 – Power Apps Portals: Styling Azure B2C for Power Apps Portals The 3 Phases for Using Multi-Select Option Sets in Flow with Microsoft Forms Part 3 – PowerApps Portals: Azure B2C and Power Apps Portals – User Flow for Signup and Signin Part 2 - Power Apps Portals: New Application Registration in Azure B2C for our Power Apps Portal Part 1 – Power Apps Portals: Creating a New Azure AD B2C Tenant The Automation Bot: Launching Contextual Flow from Teams Creating a New Bot for Teams Debugging your Teams Bot using Ngrok
Contact Us

Want expert advice or a demo?

Get in touch now and see how we can help your business grow.

  • Name
  • Email Address
  • Phone Number

Understanding Your Challenges

Our strong understanding of CRM and emerging technologies within the Microsoft environment means we deliver the right solutions for you.

Proven Real-World Solutions

As a leader in the field of Dynamics solutions, our pedigree developing and delivering real-world solutions is unsurpassed.

Long Term Support

We provide support beyond our design, implementation and 'go-live' delivery using Sprints and continual updates to our AppSource apps.

CRMCS | Design by Thinktank Marketing | Citrus-Lime Limited

To improve your experience today and in the future, this site uses cookies. Read our full Privacy Policy & Cookie information here I Understand