Our support engineers have assembled the top recommended solutions for you.
Microsoft Dynamics AX 2012CRM Connector in Microsoft Dynamics AX 2012Financials Management in Microsoft Dynamics AX 2012Upgrading to Microsoft Dynamics AX 2012
Microsoft Dynamics AX 2009
Application Object Server (AOS)
Enterprise Portal and Role Centers
Inventory Costing in Microsoft Dynamics AX 2009
SSRS and SSAS Integration
I am using AX 2012 R2, Does anyone knows how can i refresh my test enviroment business data ?
Will backup and restore of the business data DB do the work?
If R2 is anything like regular 2012, a backup/restore of the DB will do just fine. We constantly are refreshing dev environments with backups from our live server. If you are grabbing data from a different server, just make sure you change any settings still pointing to live server! Such as Report Server, Analysis Server, Enterprise portal, batch servers, etc etc (AX 2012). Not sure how much harm you could do, but better safe than sorry.
If you are grabbing an old backup from your test environment, then a straight up backup/restore should do the trick. Just keep in mind all the things AX stores in a database (users, settings, etc) and make sure you get a good backup after all that is setup. Also keep in mind if you refresh the AX database, any report updates you've deployed to the report server are still there. You'll have to redeploy the reports from the AOT to "undo" your report updates.
Interesting. I didn't know that about R2, but it makes sense.
I have the luxury of having my own VM AX environment - so yes, I do something like you say. I'll usually export what I've been working on, then restore the DB, then import my project(s) again.
I think just restoring the Data DB would do the trick. I would back up both first just to be safe, so that in the event something gets messed up you can revert back. I like virtual machines for this reason: I can just take a snapshot, restore the db and if all goes well, delete the snapshot (or revert back to the snapshot if it fails).
In R2 you can backup your business database and restore it your other environment (test or dev). The application is persisted in the model-database in R2.
And as Andy pointed out, you should make sure your environment specific data is updated to reflected. The Reporting Server settings are located in the table SRSSERVERS. If you want your batchjobs to work in the new environment, update BATCHSERVERGROUP and BATCH to use the correct SERVERID. You can also disable your batches by setting STATUS to 0 in BATCH and BATCHJOB. I normally clean out SYSSERVERCONFIG, SYSSERVERSESSIONS and SYSSQMSETTINGS while the AOS is down. These tables will be initialized with new and fresh unique values. You can create yourself a SQL script you can run after each time you update your environments with fresh data, and run it after the database restore and before you start the AOS.
Tommy Skaue | Dynamics AX Developer from Norway | http://yetanotherdynamicsaxblog.blogspot.no/ | www.axdata.no
Thank you for your answer Andy ,
The R2 DB is different, the model store and the business data are stored in separate databases. In other versions of Microsoft Dynamics AX 2012, the model store and business data are stored in a single database.
Taking in consideration all you said above regarding the settings –
How do you refresh Dev environment with live ?
If there is ongoing dev work – by doing a backup/restore of the DB you will lose all your new development, since the DB (ax 2012) that is restored contains the live server model store.
Thinking about it..
Are you doing the following steps for ax 2012 :
1.Full backup of live DB.
2.Export model store of Dev environment.
3.Restore the DB of the live environment on Dev environment.
4.Import model store of dev environment.
Am I missing something ?
Having said that, since on R2 the business data and model store are stored in separate DB.
I was thinking to avoid all the steps above and just backup the business data DB from live and restore it on the Dev environment.
Do you think it is possible?
Thank you very much guys !
Other Microsoft Sites
I'm a Customer
I'm a Partner
Use the official Twitter tags:
#MSDYNCOMM | #CONV13