News and Announcements icon

Dynamics 365 CommunityForums Finance | Project Operations, Human Resources, ... How to update data fro...

Finance | Project Operations, Human Resources, ...

Suggested answer

How to update data from production to test env.

(0) Share

Report

Report

Posted on by Siddhant Singh

510

Hi all,

How to update data from production to test env.

Thanks and regards

Siddhant Singh

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

nmaenpaa 101,156 Moderator on at

Like (0)

Report

RE: How to update data from production to test env.

1. Back up business and model databases from Prod

2. Stop Test AOS

3. Restore the backups to Test

4. Update all environment specific data to correspond with the test system (for example SSRS settings, Server configuration, AIF endpoints.

5. Start test AOS

Step 4 is unique for every scenario, you need to identify all such settings in your system, and ideally write a SQL script that updates those settings after you have restored the backup to your Test system. And before you start the AOS.

You should be able to find a lot of discussions, instructions and examples by using a web search engine.

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 292,933 Super User 2025 Season 1

#2

Martin Dráb 231,801 Most Valuable Professional

#3

nmaenpaa 101,156 Moderator

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans