How to backup the data of a single table from AX2012

(1) Share

Report

Posted on by Daniel Mora

148

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.

All responses (4)

Answers (1)

Martin Dráb 230,198 Most Valuable Professional on at

Like (0)

Report

RE: How to backup the data of a single table from AX2012

Use the data import/export framework (DIXF). Just create an entity with Entity type = Table for your table.
GirishS 27,832 Super User 2024 Season 1 on at

Like (1)

Report

RE: How to backup the data of a single table from AX2012

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.
Daniel Mora 148 on at

Like (1)

Report

RE: How to backup the data of a single table from AX2012

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?
Verified answer

GirishS 27,832 Super User 2024 Season 1 on at

Like (1)

Report

RE: How to backup the data of a single table from AX2012

Hi Daniel Mora,

You can export data to excel. Open table browser and press "Ctrl + t" to export data to excel.

Thanks,

Girish S,