I want to know how to backup the data of a single table in AX2012 before I make a big update. I'm working in a private virtual machine from a client company and I don't have access to SQL Server Management Studio, so I was wondering how to backup the data of just one table, I don't need the whole database and that will take too long. Also, the AX2012 does not have version control activated.
Use the data import/export framework (DIXF). Just create an entity with Entity type = Table for your table.
I think you need to write code to import data from excel.
Also after exporting data to excel please make sure that all data from table are exported to excel. Just check the count in excel and in table browser.
Refer to the below blog for excel import.
http://imdaxershiv.blogspot.com/2016/08/x-code-for-import-data-from-excel-using.html?m=1
Thanks,
Girish S.
Thank you so much Girish,
And if I want to reverse the data from the Excel to the AX again what would be the process?
Hi Daniel Mora,
You can export data to excel. Open table browser and press "Ctrl + t" to export data to excel.
Girish S,
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Andrés Arias as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Sohaib Cheema 756 User Group Leader
André Arnaud de Cal... 629 Super User 2025 Season 2
Martin Dráb 514 Most Valuable Professional
