Announcements
Can someone share the steps how to moving AX transaction database between environments. E.g. From Production to TEST.
Or if you have up to date document, can you share.
Thanks
*This post is locked for comments
Importing Of Data can be done in 3 types:
1) Add Excel Add In Option, Select the fields and Import from excel sheet. This is the easiest way
2) Write a code from technical consultant and import the data
3) Use DIMF Functionality.
Can I just restore backup of the Production Transaction database in Test environment directly?
Depends on what you mean with the term "transaction database". AX has two (well, actually a lot more, but these are not relevant here) databases, the application database and the business data database. The business data database contains the main, setup and transaction data. So if you are just after the transaction part of this database, things can get tricky and the Data Import/Export Framework (DIXF) or the Test Data Transfer Tool (TDTT) are probably your best bet. But if you are ok with moving the whole business data database to test, you can use the SQL backup and restore functionality. Be aware that there may be some data you still have to change after restore such as interface parameters or user accounts. For this reason I would recommend using TDTT also for moving the whole database because you can exclude specific tables, records or fields from the move.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Jump in, show your community spirit, and win prizes!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
CP04-islander 21
dserp 4
dekion 4
