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
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.
Can I just restore backup of the Production Transaction database in Test environment directly?
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.
#1
André Arnaud de Cal...
291,391
Super User 2024 Season 2
#2
Martin Dráb
230,445
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
