Which upgrade codeunit to choose when upgrading Nav

mo_x

Hey,
I have a quick question. Which upgrade codeunit should i choose to ryn data upgrade for nav? I'm upgrading from 2013 r2 to 2017. I'm following the guide provided by microsoft.
You can find the default upgrade toolkit objects in the UpgradeToolKit\Data Conversion Tools folder on the Microsoft Dynamics NAV 2017 installation media (DVD). Choose the FOB that matches the Dynamics NAV version from which you are upgrading:

Upgrade7001000.FOB for Microsoft Dynamics NAV 2013
Upgrade7101000.FOB and Upgrade710HF1000.FOB for Microsoft Dynamics NAV 2013 R2
Upgrade8001000.FOB for Microsoft Dynamics NAV 2015
Upgrade9001000.FOB for Microsoft Dynamics NAV 2016
You have exported the permission sets and permissions as XML files.

generaljim99

It appears that they are the same except possibly for 2 objects. They all have the same dates and times, and include the same objects, but Table 104026 is larger in 7101000, and Codeunit 104025 is also larger in 7101000. So if anyone has the answer, I would also like to hear what it is. I don't really want to have to import each one and export to text then compare them. Microsoft should have better documentation than that! Thanks!

lynge

I had the same question myself and got an answer from Microsoft.

From 2013R2 to 2017 you need to import one of the 710xxxx.FOB codeunits.
The other ones are only if you upgrade FROM 2013, 2015 or 2016 - there you need to select the right one.

If you run 2013R2 RTM (the first release) you need the 7101000.FOB, if you on the other hand are running 2013R2 Cumulative Update 1 or later, you need 710HF1000.fob. This is because there were a scema change in CU1.

I've blogged about it (unfortunately in Danish) here: http://blog.systemconnect.dk/?p=1113

generaljim99

Thanks Lynge. I went ahead and did the compares, and the non-HF fob deals with a field in the Sales Header table (36) called Direct Debit Mandate ID (field 1200), and also table 1230 - SEPA Direct Debit Mandate. So in English ( ), if you have that table and that field in the Sales Header table, I guess you want to use the Upgrade7101000.fob, and if you don't, then use Upgrade710HF1000.fob. Since I was thrown at this upgrade task with not much information, I didn't want to try to figure out which CU (if any) the customer had upgraded to or not. This is the quick way to figure it out. I think...