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
- 311 Dynamics CRM
- 110 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
DataUpgradeMgt.SetTableSyncSetup(TableA, TableB, move) but nothing happens
Sunset
Member Posts: 201
For an upgrade from 2016 to 2018 we have cone over the customers modifications, and have done some restructuring. Both in regards to ekstra fields in regular tabels, and for added tables.
The solution is working, so now I am starting on the upgrade, and since we will be using/needing som of the old values I figured I might as well just add them to Codeunit 104000 and let the upgrade take care of it.
But for some reason the customers tables seem to be completely ignored by the upgrade. Has anybody else experienced this behaviour?
For clarity:
I'm following https://docs.microsoft.com/en-us/dynamics-nav/upgrading-the-data
The customer has in the current solution Table 50010 "Fixed Prices", in the new system this table does not exist but we need some of the values in Table 60010 "Custumer fixed prices".
My train of thinking was that
1. I create a new table 91010 "UPG Fixed Prices" as a copy of 50010
2. Add DataUpgradeMgt.SetTableSyncSetup"(Database::"Fixed Prices", Database::"UPG Fixed Prices", TableSynchSetup.Mode::Move) to GetTableSyncSetupW1
3. Create a function within 104000 Called UpgradeFixedPrice and make sure it is set to UpgradePerCompany, that handles the datamigration from table 91010 to 60010.
However when I follow the conversion steps it seems like the data is never moved from 50010 to 91010, and therefor I get no data to my new table. Looking at the tables after the upgrade only 50010 has any values. Both 91010 and 60010 are empty.
If I've understood the steps correctly then Task 12 should move all data from 50010 to 91010 and Task 13 should fire of my datamigration.
What am I missing?
The solution is working, so now I am starting on the upgrade, and since we will be using/needing som of the old values I figured I might as well just add them to Codeunit 104000 and let the upgrade take care of it.
But for some reason the customers tables seem to be completely ignored by the upgrade. Has anybody else experienced this behaviour?
For clarity:
I'm following https://docs.microsoft.com/en-us/dynamics-nav/upgrading-the-data
The customer has in the current solution Table 50010 "Fixed Prices", in the new system this table does not exist but we need some of the values in Table 60010 "Custumer fixed prices".
My train of thinking was that
1. I create a new table 91010 "UPG Fixed Prices" as a copy of 50010
2. Add DataUpgradeMgt.SetTableSyncSetup"(Database::"Fixed Prices", Database::"UPG Fixed Prices", TableSynchSetup.Mode::Move) to GetTableSyncSetupW1
3. Create a function within 104000 Called UpgradeFixedPrice and make sure it is set to UpgradePerCompany, that handles the datamigration from table 91010 to 60010.
However when I follow the conversion steps it seems like the data is never moved from 50010 to 91010, and therefor I get no data to my new table. Looking at the tables after the upgrade only 50010 has any values. Both 91010 and 60010 are empty.
If I've understood the steps correctly then Task 12 should move all data from 50010 to 91010 and Task 13 should fire of my datamigration.
What am I missing?
Don't just take my word for it, test it yourself
0
Best Answer
-
Sunset
Member Posts: 201
I found the missing part. Since I am not doing any changes to the 50010 table, it will not be inserted in the Synch Table, and therefor addind it to DataUpgradeMgt.SetTableSyncSetup has no effect.
Instead you have to have the UpgradePerCompany function retrieve it from the original table.Don't just take my word for it, test it yourself0
Answers
Instead you have to have the UpgradePerCompany function retrieve it from the original table.