How to restore F&O uat database on Unified development environment (F&O)

Question

I have created a Unified Development Environment (UDE) in Microsoft Dynamics 365 Finance & Operations, but the environment currently contains the Contoso demo database. I want to replace the Contoso database with the Sandbox environment database in the UDE. Could you please suggest the correct procedure to restore or move the Sandbox database to the Unified Development Environment?

Answer 1

Hi @Asadullah Iqbal

Regarding your issue, because this is specific to Dynamics 365 environment management, particularly around Unified Development Environments (UDE) and database movement between sandbox environments. I highly suggest reposting your question in the Dynamics community forum, as that community is more focused on Dynamics‑related issues and have product experts and engineers actively support these topics. 

Once again, I apologize for redirecting you to a different community as the members of the posted category focus on users with Microsoft 365 concern and have limited knowledge about Dynamic, so to get a quick and better assistance, we redirect you in the correct way.    

Thank you for your patience and understanding, if you have any other questions or need further assistance, feel free to ask.    

---

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread. 

Answer 2

Restoring or moving a sandbox/UAT database into a Unified Development Environment (Tier 1/UDE) is not supported directly via point‑in‑time restore or LCS “Move database” between those environment types in the provided material. The documented database movement options focus on:

• Point‑in‑time restore within the same environment (UAT or Production) using LCS → Maintain → Move database → Point‑in‑time restore.
• Refreshing a UAT environment from Production.
• Exporting a UAT database to a .bacpac and then manually importing that .bacpac into Tier 1 developer environments.

From the context, the supported pattern for getting UAT data into a developer‑type environment is:

1. In LCS, open the sandbox/UAT Environment details.
2. Select Maintain → Move database.
3. Use Export database to create a .bacpac backup of the sandbox/UAT database to the Asset Library (Database backups section).
4. Download the .bacpac from the Asset Library.
5. Import that .bacpac manually into the SQL Server instance of the Tier 1/Unified Dev environment (outside of LCS) using standard SQL tooling.

The context explicitly notes that the .bacpac files exported from sandbox can be “manually downloaded to your Tier 1 developer environments for import,” which is the supported route for getting sandbox data into a development environment.

---

References:

• Export a copy of the standard user acceptance testing (UAT) database