Skip to main content

Notifications

Microsoft Dynamics AX (Archived)

Archiving old data

Posted on by 1,572

Dear Friends,
I have a question:
1/ The Database of AX2012 R3 is huge (>2TB). I want to archive data in the few years ago. Can I do?. How?.

*This post is locked for comments

  • Oscar AR Profile Picture
    Oscar AR 5 on at
    RE: Archiving old data

    Anudeep1806 were you able to find any alternative to IDMF?

  • Anudeep1806 Profile Picture
    Anudeep1806 70 on at
    RE: Archiving old data

    Hello Team,

    We are working for one of the clients and they are on AX 2012 R3 and looking to archive the data. From our past experience, IDMF is not a suitable tool as it has issues during archiving and purging.

    Is there any other tool that we can use for data archival ?

    Please suggest.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Archiving old data

    Martin, Can we use IDMF – Archiving Restoring and Purging data tool with Dynamics AX 2012 R3 CU12 version for data archiving and purging?

  • Martin Dráb Profile Picture
    Martin Dráb 230,188 Most Valuable Professional on at
    RE: Archiving old data

    Cuong, please use titles that describe the topic of your question. I've changed your title Some questions of Dynamics 2012 R3 to the current one.

    I've also fixed the version tag (from Microsoft Dynamics AX (current version) to Microsoft Dynamics AX 2012) and removed some unrelated categories, such as Connector for CRM. Please pay more attention to it next time.

  • Suggested answer
    guk1964 Profile Picture
    guk1964 10,877 on at
    RE: Some questions of Dynamics 2012 R3

    There are also clean up / purge routines worth considering. All cleanup jobs are available in module > Periodic > Cleanup section

    Check out which are e.g. the top 10 largest tables , also look at your log files to see what can be purged.

    IDMF will also help you archive data. For custom tables see https://blogs.msdn.microsoft.com/axsupport/2016/03/22/idmf-archiving-restoring-and-purging-data-from-a-custom-table/

  • Suggested answer
    Mea_ Profile Picture
    Mea_ 60,278 on at
    RE: Some questions of Dynamics 2012 R3

    There is IDMF tool in 2012 to archive data https://blogs.msdn.microsoft.com/axsupport/2016/03/22/idmf-archiving-restoring-and-purging-data-from-a-custom-table/

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.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,253 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans