Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / Archiving Database of ...
Microsoft Dynamics NAV (Archived)

Archiving Database of Navision 2009

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

We are using Navision 2009 Classic and we are thinking of archiving our database so that transactions/information that is before 2014 we will archive it from the live database - to help with the performance of the live database and more manageable.

We have thought of doing this:

1. Create a new database base copy as the "read-only" archive for future access

2. Delete Sales Header/Line, Purchase Header/Line (obsolete for more than 3 years) from the live database to compact the size for performance.

If we do it this way, is there any concern for the live database regarding data integrity with this approach?

What is the more common approach for archiving data for Navision 2009 or is there any archiving tool that we can use for Navision 2009 that is out there from 3rd party ?

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Archiving Database of Navision 2009

    Will do.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Archiving Database of Navision 2009

    Yes, it was successful.

  • ManishS Profile Picture
    ManishS 6,578 on at
    RE: Archiving Database of Navision 2009

    Before deleting you need to look out for your reports which are based on these table.

  • Suggested answer
    Alexander Ermakov Profile Picture
    Alexander Ermakov 28,094 on at
    RE: Archiving Database of Navision 2009

    Was it successful?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Archiving Database of Navision 2009

    We started to use the Data Deletion >>> Sales Documents >>> Delete Archive Sales Quote Versions and Delete Archive Sales Order Versions.

    We will be working on the Purchase Documents to Delete the Archive Purchase Quote Versions and Delete Archive Purchase Order Versions.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Archiving Database of Navision 2009

    Yes, that is what we are thinking. Our Database is quite big about 163499984 KB

    We have about 1,702673 records of the Closed Sales Header/Sales Line and Closed Purchase Header/Purchase Lines.

  • Suggested answer
    Alexander Ermakov Profile Picture
    Alexander Ermakov 28,094 on at
    RE: Archiving Database of Navision 2009

    Are you planning to delete posted sales/purchase orders headers and lines? How big is your data actually - how many records those tables have?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Archiving Database of Navision 2009

    No, we have not done it yet and is looking into it. Our NAV has a lot of modification - we are trying to find other ways to archive our closed sales order and closed purchase order which is not standard.

    Will keep you posted on what we will do.

  • Verified answer
    TharangaC Profile Picture
    TharangaC 23,116 on at
    RE: Archiving Database of Navision 2009

    Were you able to archiving the Database using Data Deletion functionality?  If so please verify answers, or if you followed different approach please do share it with the community.

  • Verified answer
    TharangaC Profile Picture
    TharangaC 23,116 on at
    RE: Archiving Database of Navision 2009

    Refer below link : http://www.dynamicsbusiness.co.uk/2015/07/how-do-i-archive-data-with-dynamics-nav.html

    It is not for 2009 version, but you might get a idea.

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,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans