mibuso.com

Microsoft Business Solutions online community
It is currently Mon Sep 01, 2014 11:06 pm

All times are UTC + 1 hour [ DST ]




Post new topic Reply to topic  [ 3 posts ] 
Author Message
 Post subject: [Solved] Tool of compression of data
PostPosted: Wed May 23, 2012 12:21 pm 
Offline

Joined: Tue Dec 13, 2005 11:15 am
Posts: 58
Location: Réau
Country: France (fr)
Hello,

I have a SQL Server Database in Dynamics 5.01 with a Table too large, and have many keys (15).
This table represents 80 % of the size of the Database!
A means or a tool exists to compress it or create an archive compressed ?

Thanks in advance.

Regards,

Rudy.Weinling


Top
 Profile E-mail  
 
 Post subject: Re: Tool of compression of data
PostPosted: Wed May 23, 2012 1:17 pm 
Offline

Joined: Thu Apr 26, 2007 2:28 pm
Posts: 325
Location: Lawrenceburg, Kentucky
Country: United States (us)
Hi,

Yes there are tools to compress data within NAV. But be very careful. Dynamics NAV 5.0SP1 comes with several archive tables.
For example you can "easily" archive older purchase and sales orders. However, when it comes to the Item Ledger Entry or G/L Entry it will be very hard and often does not yield the desired effect. There are many posts on this forum about the (Item Ledger Entry, G/L Entry) date compression and there are also many blogs about it.

Please read up on those posts/blogs and you will find out what is best for your situation.

Hope this helps,

Regards,

Willy

_________________
Fostering a homeless, abused child is the hardest yet most rewarding thing I have ever done.


Top
 Profile  
 
 Post subject: Re: Tool of compression of data
PostPosted: Wed May 23, 2012 4:29 pm 
Offline
MVP Microsoft Dynamics NAV
NAV TechDays 2014 attendee

Joined: Thu Jul 31, 2003 12:00 pm
Posts: 640
Location: Nürnberg
Country: Germany (de)
If you think about physical compression using SQL Server 2008 EE "Data Compression" this might help you:
http://dynamicsuser.net/blogs/stryk/archive/2011/02/15/data-compression.aspx

_________________
Jörg A. Stryk (MVP - Dynamics NAV)
NAV/SQL Performance Optimization & Troubleshooting
STRYK System Improvement
The Blog - The Book - The Tool


Top
 Profile E-mail WWW  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 3 posts ] 

All times are UTC + 1 hour [ DST ]


Who is online

Users browsing this forum: No registered users and 15 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum


Search for:
Jump to: