Compressed Item Ledger Entries & 3.7-to-2009 Conversion.
c_smith
Member Posts: 8
Hello,
We are in the process of making the move from 3.7 to 2013, and I was hoping that I could get any feedback on the process from anyone that has made a similar move. Personally, I have never been a part of this sort of upgrade/conversion. However, my supervisor has experience with both installing Navision here back in 1999, as well as upgrading us to the 5.0 executables that we are on now several years ago.
The step that we are on at the moment is the conversion of the native 3.7 database to the NAV 2009 SQL database. One particular issue we are trying to gather information on is whether compressing item ledger entries in 3.7 prior to converting to the 2009 SQL database will cause any headaches for us, as our item ledger table is quite large and we don't need detail past a couple years back.
We were looking into this because back when my supervisor looked into moving from 3.7 to 2009 a few years back, he was told by a few people that compressed data did more harm than good in the conversion process. Is this actually the case, or will us compressing item ledger entries in 3.7 prior to converting to 2009 (and ultimately 2013) work fine?
I'd be happy to provide additional information, if needed. And any input/advice on this would be greatly appreciated!
We are in the process of making the move from 3.7 to 2013, and I was hoping that I could get any feedback on the process from anyone that has made a similar move. Personally, I have never been a part of this sort of upgrade/conversion. However, my supervisor has experience with both installing Navision here back in 1999, as well as upgrading us to the 5.0 executables that we are on now several years ago.
The step that we are on at the moment is the conversion of the native 3.7 database to the NAV 2009 SQL database. One particular issue we are trying to gather information on is whether compressing item ledger entries in 3.7 prior to converting to the 2009 SQL database will cause any headaches for us, as our item ledger table is quite large and we don't need detail past a couple years back.
We were looking into this because back when my supervisor looked into moving from 3.7 to 2009 a few years back, he was told by a few people that compressed data did more harm than good in the conversion process. Is this actually the case, or will us compressing item ledger entries in 3.7 prior to converting to 2009 (and ultimately 2013) work fine?
I'd be happy to provide additional information, if needed. And any input/advice on this would be greatly appreciated!
0
Comments
-
My advice. Don't do it.
You'll get more problems than what it's worth.Confessions of a Dynamics NAV Consultant = my blog
AP Commerce, Inc. = where I work
Getting Started with Dynamics NAV 2013 Application Development = my book
Implementing Microsoft Dynamics NAV - 3rd Edition = my 2nd book0 -
Alex is correct. Microsoft discontinued the feature because it did not work correct and you cannot upgrade compressed entries to newer versions.0
-
So a database where compression is done, cannot be upgraded?0
-
From what I understand, yes, a database with compressed entries cannot be upgraded using the standard scripts.0
-
This aligns with what my boss had heard a few years back. Thanks for helping us confirm this is still the case.0
-
any links or info where ms says you can't upgrade?0
Categories
- All Categories
- 75 General
- 75 Announcements
- 66.7K Microsoft Dynamics NAV
- 18.8K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 610 NAV Courses, Exams & Certification
- 1.9K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 251 Dynamics CRM
- 103 Dynamics GP
- 6 Dynamics SL
- 1.5K Other
- 991 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 28 Design Patterns (General & Best Practices)
- Architectural Patterns
- 9 Design Patterns
- 4 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1K General Chat
- 1.6K Website
- 77 Testing
- 1.2K Download section
- 23 How Tos section
- 249 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
