Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 304 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 993 SQL General
- 384 SQL Performance
- 34 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 260 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
NAV 2009 to 2013 - Dimension data migration
evildave
Member Posts: 21
Hi All,
I've been running through a upgrade internally for a 2009 database into 2013. Everything has been going ok and i haven't been hitting to many issues that i can't resolve by either searching here or trail and error.
However there is one area that i'm unable to find much information on, and haven't had much luck understanding it by myself. The Dimensions... I know that in 2013 we've moved to this whole Dimension Set ID approach and i understand why they decided to switch over to that system, but what i can't understand is how i migrate data from 2009 (with its old Dimension setup) to 2013 and retain the dimensions.
E.g - Sales Invoice Line Table
2009;
Dimensions for each line exist both on the record itself (dim 1 & 2) and the posted document dimensions table.
2013;
Single Dimension Set ID field on record and Dimension Set Entries table
These two formats are obviously imcompatible and i cannot migrate information across like i am with other tables via xmlports.
Is the migration and relinking of this data handled by the Upgrade toolkit normally? if thats all i'm missing then i guess it could be an easy answer and i'll get cracking on that side but i could not find anything specifically mentioned in the notes that the toolkit handled the dimensions.
Appreciate your time gents,
Dave
I've been running through a upgrade internally for a 2009 database into 2013. Everything has been going ok and i haven't been hitting to many issues that i can't resolve by either searching here or trail and error.
However there is one area that i'm unable to find much information on, and haven't had much luck understanding it by myself. The Dimensions... I know that in 2013 we've moved to this whole Dimension Set ID approach and i understand why they decided to switch over to that system, but what i can't understand is how i migrate data from 2009 (with its old Dimension setup) to 2013 and retain the dimensions.
E.g - Sales Invoice Line Table
2009;
Dimensions for each line exist both on the record itself (dim 1 & 2) and the posted document dimensions table.
2013;
Single Dimension Set ID field on record and Dimension Set Entries table
These two formats are obviously imcompatible and i cannot migrate information across like i am with other tables via xmlports.
Is the migration and relinking of this data handled by the Upgrade toolkit normally? if thats all i'm missing then i guess it could be an easy answer and i'll get cracking on that side but i could not find anything specifically mentioned in the notes that the toolkit handled the dimensions.
Appreciate your time gents,
Dave
0
Comments
I think you can't do it directly but did you check these pages?
Dimension Set Entries Overview
Code Examples of Changed Patterns in Modifications
I think that you'll have to make te changes needed to your Objects and then probably the best you can do is copy the information through a SQL Script prepared for it.
Hope it helps
As its a big change the upgrade toolkit should handle it.
Did you check the objects which needed to be imported in NAV from the toolkit.
Manish