Microsoft Dynamics AX (Archived)

Refresh STAGE with PROD Data

(0) Share

Report

Posted on by ScorpioDax

333

Hi Guys,

I need to refresh our STAGE with PROD data so we can debug and fix issues that pop up in PROD.

I am aware of the procedure for recreating the staging environment from the production environment as described in the Deploying CUSTOMIZATIONS ACROSS MICROSOFT DYNAMICS ENVIRONMENTS guide. But i am confused where the SQL DB backup and restore comes into play? I have SQL scripts from our outside vendor to run that will refresh data on our environments. When can that be completed? Can it be done before or after the model export and upload?

Here are the steps i am going to take but do not know where the SQL DB restore should be placed.

Drain users, reject new clients - STAGE
close active sessions - STAGE
stop all aos instances - STAGE
Export model to backup model - STAGE
Export Model Store - PROD
Import model store - STAGE
Import backup model - STAGE
Start AOS - STAGE
compile - STAGE
Synchronize DB - STAGE
set AOS to accept new clients - STAGE

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (0)

ScorpioDax 333 on at

Like (0)

Report

HI Crispin

For step 7 i agree but it does show that here in the guide.

for step 11 i have a SQL script that will extract all the settings from PROD and then i will restore the DB and run against the restored DB.

Was this reply helpful? Yes No
Suggested answer

Rachit 4,015 User Group Leader on at

Like (0)

Report

Do you want to restore data or data + code from PROD to Stage?

Some conceptual information --> If you do only model store import then you are basically only restoring code from PROD.

If you restore SQL DB Backup then it contains Code+ data. Depending on your AX2012 version, your code and modelstore can reside in same or different databases. Assuming you are working on AX2012 FP version then the code and modelstore reside in same database. From AX2012 R2 and above MS splitted these databases.

What you want to achieve should decide the strategy.

Restore only DATA from prod --> Summary of steps will be to take backup of your Staging code in form of model store, restore PROD DB and then import your model store backup. This way your data is restored from PROD and Staging code is also preserved.

Restore DATA + CODE --> In this case you can do a full SQL DB restore from PROD to Staging.

You will need to run other scripts to update your system configuration/SSRS /EP etc settings to Staging.

Hope this helps

Was this reply helpful? Yes No
ScorpioDax 333 on at

Like (0)

Report

Hi Rachit,

I would like to restore the DATA + CODE , i have some SQL scripts that i can use to extract all the settings from STAGE. We have AX 2012 RTM

Was this reply helpful? Yes No
ScorpioDax 333 on at

Like (0)

Report

When you say delete critial parameters do you mean run the SQL scripts to populate the settings?

Was this reply helpful? Yes No
ScorpioDax 333 on at

Like (0)

Report

Got it.

Are there any steps i will need to be aware of when backing up and restoring the DBs? I am creating a list for our DBA to follow. That would be awesome.

Was this reply helpful? Yes No

Community site session details

Refresh STAGE with PROD Data

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

Featured topics

Product updates

Community site session details

Refresh STAGE with PROD Data

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

Featured topics

Product updates