Archiving Database of Navision 2009

(0) Share

Report

Posted on by Community Member

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

I have the same question (0)

All responses (16)

Answers (3)

Suggested answer

Amol Salvi 18,698 on at

Like (0)

Report

There is one utility provided by NAV i.e. Date compression

Check this link

msdn.microsoft.com/.../hh167693(v=nav.90).aspx

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Where can we find this utility - Date Compression?

Is this available in Navision 2009 version? The link seems to only refer to Navision 2016, 2015 and 2013.

If we are on Navision 2009 - if this utility is not available, what is the best way to handle this ?

Was this reply helpful? Yes No
Suggested answer

Amol Salvi 18,698 on at

Like (0)

Report

In NAV 2009 go to Administration--> IT Administration--> Data Deletion--> Date Compression

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

We are not only looking for the Date Compression. We have closed sales order, purchase order and archived sales order that we want to archive out from our live database. What is the best way to handle these things ?

Was this reply helpful? Yes No
Suggested answer

Amol Salvi 18,698 on at

Like (0)

Report

Hi,

For this also there is utility provide by NAV i.e Data Deletion

You can find this in Administration--> IT Administration--> Data Deletion

For Sales --> Administration--> IT Administration--> Data Deletion--> Sales Documents

and vice versa

Take backup before executing these activities.

Was this reply helpful? Yes No
Verified answer

Tharanga Chandrasekara 23,118 on at

Like (0)

Report

As Amol mention you can use the Data Deletion functionality provided in the Dynamics NAV. However it is always better to keep a copy of the original database for future reference.

Was this reply helpful? Yes No
Verified answer

Tharanga Chandrasekara 23,118 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Verified answer

Tharanga Chandrasekara 23,118 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Community Member on at

Like (1)

Report

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.

Was this reply helpful? Yes No
Suggested answer

Alexander Ermakov 28,096 on at

Like (0)

Report

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

Was this reply helpful? Yes No