Tuesday, 13 March 2018

Upgrade Steps from NAV 2017 CU4 to NAV 2018 CU2



Upgraded one of our customers from NAV2017 CU4 to NAV2018 CU2.
Steps are:

1.     Take backup of your NAV2017 CU4 database from SQL
2.     Upload Partner License and restart service
3.     Open Extension management page in NAV2017
Uninstall standard extensions



4.     Run this command to unpublish from powershell (example)
Unpublish-NAVApp -Name "Sales and Inventory Forecast" -ServerInstance dynamicsnav110
5.     Delete records of Debugger breakpoint table from database using SSMS
6.     Stop NAV2017 CU4 service
7.     Open current NAV 2017 CU4 database in NAV 2018 CU2 environment and do the convert.
8.     Delete all objects except Tables.

NOTE: I have created all fob of NAV2018 with customizations before.

I have manually merged customizations as there are only less than 20 objects modified.
You can use power shell merge commands if there are lot of customized objects.

9.     Import all objects fob file with Replace all option from Import Work Sheet. (With Later Option in Synchronize Schema)
10.Import Upgrade toolkit fob (With Later Option in Synchronize Schema)




11.Start NAV 2018 CU2 service
12.Sync-NAVTenant in Powershell
13.Compile all objects with Validation
14.Run data upgrade from Tools->Data UpgradeàStart (you can do it from Power shell also)
15.Following objects, you have to delete from converted database.
Type
ID
Name
1
9192
Pending Company Rename
3
83
Change Global Dimensions
8
1605
Office No Company Dlg
8
1802
Assisted Setup Part
8
2502
Extension Marketplace
8
5073
Sales Cycle Stages List
8
9627
Data Source List Part
8
9626
New Page Patterns List Part

16.Delete Upgrade related objects. (Version List UPG*)
Only Publish below app, don’t install
17.Publish extensions from NAV2018CU2 DVD and install if required
Publish-NAVApp -Path "C:\Install\Dynamics NAV\NAV2018CU2\Extensions\SalesAndInventoryForecast\SalesAndInventoryForecast.navx" -ServerInstance dynamicsnav110

18.Upload Customer license and restart service