AX – D365FO – Refresh database data from a production environment to a sandbox environment (UAT) in LCS

You can use Microsoft Dynamics Lifecycle Services (LCS) to perform a refresh of the database to a sandbox user acceptance testing (UAT) environment. A database refresh lets you copy the transactional and financial reporting databases of your production environment into the target, sandbox UAT environment. If you have another sandbox environment, you can also copy the databases from that environment to your target, sandbox UAT environment.

To refresh Database follow these instructions :

  • Visit your target sandbox on the Environment Details page, and click the Maintain > Move database menu option.
  • Select the Refresh database option and choose your source environment.
  • The refresh operation will begin immediately.

Copying production data during business hours or peak hours could have an impact on the production system. It’s highly recommended to do the refresh database operation during off-peak hours and limit only one refresh operation at a time.

Copying production data to your sandbox environment for the purpose of production reporting is not supported.

To better understand the refresh functional follow the Microsoft official documentation : https://docs.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/database/database-refresh

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s