Home / Blog / Finally here: Copying CoreHR database to Sandbox

Finally here: Copying CoreHR database to Sandbox

Posted on

Many times (during the last 2 years and after 5 Dynamics 365 for Talent implementations) I had no convincing answer to the following question: how do you make a copy  – easy and completely –  of the production CoreHR database?

Because Dynamics 365 for Talent is a Hybrid Application (this is my own name, not coming from Microsoft), we have 3 products that are Power Apps native (Attract, Offer Management and Onboard) and 1 product with an Finance and Operations database  – CoreHR. (if you want to read more about the architecture click here).

Microsoft is releasing features and patches for Dynamics 365 for Talent on a weekly basis (almost) and on November the 5th and important option was published: How to copy a Core HR database.


docs.microsoft.com because I want to make sure you get the exact naming, limitations and steps. Some features might have not been released yet for all LCS environments.

I’ve also prepared an article about my view on how to completely copy you Dynamics 365 for Talent, from production to sandbox, all modules.

You can use Microsoft Dynamics Lifecycle Services (LCS) to copy a Microsoft Dynamics 365 Talent: Core HR database to a sandbox environment. If you have another sandbox environment, you can also copy the database from that environment to a targeted sandbox environment.

To copy an instance, you need to ensure the following:

  • The Core HR instance you want to overwrite must be a sandbox environment. If it isn’t, you need to contact Support to switch it. For information about contacting Support, see Get support for Microsoft Dynamics 365 Talent.
  • The environments you are copying from and to must be in the same region. You can’t copy across regions.
  • You must be an Administrator in the target environment so you can sign into it after copying the instance.
  • When you copy the Core HR database, you don’t copy the elements (apps or data) that are contained in a Microsoft PowerApps environment. For information about how to copy elements in a PowerApps environment, see Copy an environment. The PowerApps environment you want to overwrite must be a sandbox environment. You must be a global tenant admin to change a PowerApps production environment to a sandbox environment. For more information about changing a PowerApps environment, see Switch an instance.

Effects of copying a Core HR database

The following events occur when you copy a Core HR database:

  • The copy process erases the existing database in the target environment. After the copy process is completed, you can’t recover the existing database.
  • The target environment will be unavailable until the copy process is completed.
  • Documents in Microsoft Azure Blob storage aren’t copied from one environment to another. Therefore, any documents and templates that are attached won’t be copied and will remain in the source environment.
  • All users except the Admin user and other internal service user accounts will be unavailable. Therefore, the Admin user can delete or obfuscate data before other users are allowed back into the system.
  • The Admin user must make required configuration changes, such as reconnecting integration endpoints to specific services or URLs.

Copy the Core HR database

To complete this task, you first copy an instance, and then sign in to the Microsoft Power Platform Admin Center to copy your PowerApps environment.


When you copy an instance, the database is erased in the target instance. The target instance is unavailable during this process.

  1. Sign in to LCS, and select the LCS project that contains the instance that you want to copy.
  2. In your LCS project, select the Talent App Management tile.
  3. Select the instance to copy, and then select Copy


Copy an instance


4. In the Copy an instance task pane, select the instance to overwrite, and then select Copy. Wait for the value of the Copy status field to be updated to Completed.

Select instance to overwrite


5. Select Power Platform, and sign in to the Microsoft Power Platform Admin Center.


Select Power Platform


6. Select the PowerApps environment to copy, and then select Copy.

7. When the copy process is completed, sign in to the target instance, and enable Common Data Service integration. For more information and instructions, see Configure Common Data Service integration.

Data elements and statuses

The following data elements aren’t copied when you copy a Core HR instance:

  • Email addresses in the LogisticsElectronicAddress table
  • The batch job history in the BatchJobHistoryBatchHistory, and BatchConstraintHistory tables
  • The Simple Mail Transfer Protocol (SMTP) password in the SysEmailSMTPPassword table
  • The SMTP Relay server in the SysEmailParameters table
  • Print Management settings in the PrintMgmtSettings and PrintMgmtDocInstance tables
  • Environment-specific records in the SysServerConfigSysServerSessionsSysCorpNetPrintersSysClientSessionsBatchServerConfig, and BatchServerGroup tables
  • Document attachments in the DocuValue table. These attachments include any Microsoft Office templates that were overwritten in the source environment
  • The connection string in the PersonnelIntegrationConfiguration table

Some of these elements aren’t copied because they are environment-specific. Examples include BatchServerConfig and SysCorpNetPrinters records. Other elements aren’t copied because of the volume of support tickets. For example, duplicate emails might be sent because SMTP is still enabled in the user acceptance testing (sandbox) environment, invalid integration messages might be sent because batch jobs are still enabled, and users might be enabled before admins can perform post-refresh cleanup actions.

In addition, the following statuses change when you copy an instance:

  • All users except Admin are set to Disabled.
  • All batch jobs, except for some system jobs, are set to Withhold.

Environment admin

All users in the target sandbox environment, including Administrators, are replaced by the users of the source environment. Before you copy an instance, be sure that you’re an Administrator in the target environment. If you aren’t, you won’t be able to sign in to the target sandbox environment after the copy has completed.

All non-Administrator users in the target sandbox environment are disabled to prevent unwanted sign-ins in the sandbox environment. Administrators can reenable users if needed.


Read the full instructions here:




I’ve also prepared an article about my view on how to completely copy you Dynamics 365 for Talent, from production to sandbox, all modules.

Leave a Reply