Business Central Migration Steps from BC 14 to BC 20 (India Version)

 Hello Team,

List of steps for Business Central Migration from BC 14 to BC 20 (India Version)

===========================================================

1.       Import-NAVServerLicense -ServerInstance BC140 -LicenseFile 'C:\Intech_BC20.flf'

2.       Restart-NAVServerInstance -ServerInstance BC200

3.       Get-NAVAppInfo -ServerInstance BC140 -Tenant default

4.       Get-NAVAppInfo -ServerInstance BC140 -Tenant Default | % { Uninstall-NAVApp -ServerInstance BC140 -Name $_.Name -Version $_.Version -Tenant Default }

5.       Get-NAVAppInfo -ServerInstance BC140 | % { Unpublish-NAVApp -ServerInstance BC140 -Name $_.Name -Version $_.Version }

 

Issue - In this step, we get error as per below snapshot.

Solution : to resolve this issue, execute this command 2 or 3 times, error will resolved.

 

6.       Get-NAVAppInfo -ServerInstance BC140 -SymbolsOnly | % { Unpublish-NAVApp -ServerInstance BC140 -Name $_.Name -Version $_.Version }

7.       Stop-NAVServerInstance -ServerInstance BC140

8.       Execute below command as SQL Query

DELETE FROM [ABC_Client_BC_TestUpgrade].[dbo].[Server Instance]

DELETE from [ABC_Client_BC_TestUpgrade].[dbo].[Debugger Breakpoint]

 

9.       Close the BC 14 Powershell and open new powershell and execute below command.

10.   Import-Module 'C:\Program Files\Microsoft Dynamics 365 Business Central\180\Service\NavAdminTool.ps1'

11.   Invoke-NAVApplicationDatabaseConversion -DatabaseName "ABC_Client_BC_TestUpgrade" -DatabaseServer databaseVM

12.   Set-NAVServerConfiguration -ServerInstance BC200 -KeyName DatabaseName -KeyValue "ABC_Client_BC_TestUpgrade"

13.   Set-NAVServerConfiguration -ServerInstance BC200 -KeyName "DestinationAppsForMigration" -KeyValue '[{"appId":"63ca2fa4-4f03-4f2b-a480-172fef340d3f", "name":"System Application", "publisher": "Microsoft"},{"appId":"437dbf0e-84ff-417a-965d-ed2bb9650972", "name":"Base Application", "publisher": "Microsoft"}]'

14.   Set-NavServerConfiguration -ServerInstance BC200 -KeyName "UsePermissionSetsFromExtensions" -KeyValue false

15.   Set-NavServerConfiguration -ServerInstance BC200 -KeyName "EnableTaskScheduler" -KeyValue false

16.   Restart-NAVServerInstance -ServerInstance BC200

17.   Publish-NAVApp -ServerInstance BC200 -Path "C:\Erp Sw\Dynamics.365.BC.41423.IN.DVD\Applications\system application\source\Microsoft_System Application.app”

18.   Publish-NAVApp -ServerInstance BC200 -Path "C:\Erp Sw\Dynamics.365.BC.41423.IN.DVD\Applications\BaseApp\Source\Microsoft_Base Application.app”

19.   Publish-NAVApp -ServerInstance BC200 -Path "C:\Erp Sw\Dynamics.365.BC.41423.IN.DVD\Applications\Application\Source\Microsoft_Application.app”

 

Publish-NAVApp -ServerInstance BC200 -Path "C:\BC_20_Base_App_Files\Microsoft_Company Hub.app"

Publish-NAVApp -ServerInstance BC200 -Path "C:\BC_20_Base_App_Files\Microsoft_Contoso Coffee Demo Dataset.app"

Publish-NAVApp -ServerInstance BC200 -Path "C:\BC_20_Base_App_Files\Microsoft_Data Archive.app"

Publish-NAVApp -ServerInstance BC200 -Path "C:\BC_20_Base_App_Files\Microsoft_Troubleshoot FA Ledger Entries.app"

Publish-NAVApp -ServerInstance BC200 -Path "C:\BC_20_Base_App_Files\Microsoft_Email - Outlook REST API.app"

Publish-NAVApp -ServerInstance BC200 -Path "C:\BC_20_Base_App_Files\Microsoft_Email - Microsoft 365 Connector.app"

Publish-NAVApp -ServerInstance BC200 -Path "C:\BC_20_Base_App_Files\Microsoft_Email - Current User Connector.app"

Publish-NAVApp -ServerInstance BC200 -Path "C:\BC_20_Base_App_Files\Microsoft_Email - SMTP API.app"

Publish-NAVApp -ServerInstance BC200 -Path "C:\BC_20_Base_App_Files\Microsoft_Email - SMTP Connector.app"

Publish-NAVApp -ServerInstance BC200 -Path "C:\BC_20_Base_App_Files\Microsoft_Essential Business Headlines.app"

Publish-NAVApp -ServerInstance BC200 -Path "C:\BC_20_Base_App_Files\Microsoft_Late Payment Prediction.app"

Publish-NAVApp -ServerInstance BC200 -Path "C:\BC_20_Base_App_Files\Microsoft_Universal Print Integration.app"

Publish-NAVApp -ServerInstance BC200 -Path "C:\BC_20_Base_App_Files\Microsoft_OnPrem Permissions.app"

Publish-NAVApp -ServerInstance BC200 -Path "C:\BC_20_Base_App_Files\Microsoft_Payment Links to PayPal.app"

Publish-NAVApp -ServerInstance BC200 -Path "C:\BC_20_Base_App_Files\Microsoft_Recommended Apps.app"

Publish-NAVApp -ServerInstance BC200 -Path "C:\BC_20_Base_App_Files\Microsoft_Sales and Inventory Forecast.app"

Publish-NAVApp -ServerInstance BC200 -Path "C:\BC_20_Base_App_Files\Microsoft_Send To Email Printer.app"

Publish-NAVApp -ServerInstance BC200 -Path "C:\BC_20_Base_App_Files\Microsoft_Simplified Bank Statement Import.app"

Publish-NAVApp -ServerInstance BC200 -Path "C:\BC_20_Base_App_Files\Microsoft_Permissions Mock.app"

Publish-NAVApp -ServerInstance BC200 -Path "C:\BC_20_Base_App_Files\Microsoft_Test Runner.app"

Publish-NAVApp -ServerInstance BC200 -Path "C:\BC_20_Base_App_Files\Microsoft_Performance Toolkit.app"

 

 

Publish-NAVApp -ServerInstance BC200 -Path "C:\BC_20_Base_App_Files\India_Apps\Microsoft_Tax Engine.app" -SkipVerification

Publish-NAVApp -ServerInstance BC200 -Path "C:\BC_20_Base_App_Files\India_Apps\Microsoft_India Tax Base.app" -SkipVerification

Publish-NAVApp -ServerInstance BC200 -Path "C:\BC_20_Base_App_Files\India_Apps\Microsoft_QR Generator.app" -SkipVerification

Publish-NAVApp -ServerInstance BC200 -Path "C:\BC_20_Base_App_Files\India_Apps\Microsoft_India GST.app" -SkipVerification

Publish-NAVApp -ServerInstance BC200 -Path "C:\BC_20_Base_App_Files\India_Apps\Microsoft_India Gate Entry.app" -SkipVerification

Publish-NAVApp -ServerInstance BC200 -Path "C:\BC_20_Base_App_Files\India_Apps\Microsoft_India TCS.app" -SkipVerification

Publish-NAVApp -ServerInstance BC200 -Path "C:\BC_20_Base_App_Files\India_Apps\Microsoft_India TDS.app" -SkipVerification

Publish-NAVApp -ServerInstance BC200 -Path "C:\BC_20_Base_App_Files\India_Apps\Microsoft_India Voucher Interface.app" -SkipVerification

Publish-NAVApp -ServerInstance BC200 -Path "C:\BC_20_Base_App_Files\India_Apps\Microsoft_Fixed Asset Depreciation for India.app" -SkipVerification

Publish-NAVApp -ServerInstance BC200 -Path "C:\BC_20_Base_App_Files\India_Apps\Microsoft_India Reports.app" -SkipVerification

Publish-NAVApp -ServerInstance BC200 -Path "C:\BC_20_Base_App_Files\India_Apps\Microsoft_India Data Migration.app" -SkipVerification

 

Below are the app files which having one version higher than the BC 14 App Files

Publish-NAVApp -ServerInstance BC200 -Path "C:\BC_20_Base_App_Files\ABC_Client_Apps_UpdVersion\ISPL_ABC_Client_HR_Development_1.0.0.3.app" -SkipVerification

Publish-NAVApp -ServerInstance BC200 -Path "C:\BC_20_Base_App_Files\ABC_Client_Apps_UpdVersion\ISPL_ABC_Client_Development_1.0.0.4.app" -SkipVerification

Publish-NAVApp -ServerInstance BC200 -Path "C:\BC_20_Base_App_Files\ABC_Client_Apps_UpdVersion\ISPL_Quality Control_1.0.0.9.app" -SkipVerification

Publish-NAVApp -ServerInstance BC200 -Path "C:\BC_20_Base_App_Files\ABC_Client_Apps_UpdVersion\ISPL_Purchase Indent_1.0.0.5.app" -SkipVerification

Publish-NAVApp -ServerInstance BC200 -Path "C:\BC_20_Base_App_Files\ABC_Client_Apps_UpdVersion\ISPL_EInvoice and Eway Bill Development ISPL_1.0.0.1.app" -SkipVerification

 

Stop-NAVServerInstance -ServerInstance BC200

Start-NAVServerInstance -ServerInstance BC200

 

Sync-NAVTenant -ServerInstance BC200 -Mode Sync -Tenant Default\

 

 

Run Below three command one by one.

Sync-NAVApp -ServerInstance BC200 -Name "System Application" -Version 20.2.41144.41423

Sync-NAVApp -ServerInstance BC200 -Name "Base Application" -Version 20.2.41144.41423

Sync-NAVApp -ServerInstance BC200 -Name "Application" -Version 20.2.41144.41423

 

 

Sync-NAVApp -ServerInstance BC200 -Name "Company Hub" -Version 20.2.41144.41423

Sync-NAVApp -ServerInstance BC200 -Name "Contoso Coffee Demo Dataset" -Version 20.2.41144.41423

Sync-NAVApp -ServerInstance BC200 -Name "Data Archive" -Version 20.2.41144.41423

Sync-NAVApp -ServerInstance BC200 -Name "Troubleshoot FA Ledger Entries" -Version 20.2.41144.41423

Sync-NAVApp -ServerInstance BC200 -Name "Email - Outlook REST API" -Version 20.2.41144.41423

Sync-NAVApp -ServerInstance BC200 -Name "Email - Microsoft 365 Connector" -Version 20.2.41144.41423

Sync-NAVApp -ServerInstance BC200 -Name "Email - Current User Connector" -Version 20.2.41144.41423

Sync-NAVApp -ServerInstance BC200 -Name "Email - SMTP API" -Version 20.2.41144.41423

Sync-NAVApp -ServerInstance BC200 -Name "Email - SMTP Connector" -Version 20.2.41144.41423

Sync-NAVApp -ServerInstance BC200 -Name "Essential Business Headlines" -Version 20.2.41144.41423

Sync-NAVApp -ServerInstance BC200 -Name "Late Payment Prediction" -Version 20.2.41144.41423

Sync-NAVApp -ServerInstance BC200 -Name "Universal Print Integration" -Version 20.2.41144.41423

Sync-NAVApp -ServerInstance BC200 -Name "OnPrem Permissions" -Version 20.2.41144.41423

Sync-NAVApp -ServerInstance BC200 -Name "Payment Links to PayPal" -Version 20.2.41144.41423

Sync-NAVApp -ServerInstance BC200 -Name "Recommended Apps" -Version 20.2.41144.41423

Sync-NAVApp -ServerInstance BC200 -Name "Sales and Inventory Forecast" -Version 20.2.41144.41423

Sync-NAVApp -ServerInstance BC200 -Name "Send To Email Printer" -Version 20.2.41144.41423

Sync-NAVApp -ServerInstance BC200 -Name "Simplified Bank Statement Import" -Version 20.2.41144.41423

Sync-NAVApp -ServerInstance BC200 -Name "Permissions Mock" -Version 20.2.41144.41423

Sync-NAVApp -ServerInstance BC200 -Name "Test Runner" -Version 20.2.41144.41423

Sync-NAVApp -ServerInstance BC200 -Name "Performance Toolkit" -Version 20.2.41144.41423

 

Sync-NAVApp -ServerInstance BC200 -Name "Tax Engine" -version 20.2.41144.41423

Sync-NAVApp -ServerInstance BC200 -Name "India Tax Base" -version 20.2.41144.41423

Sync-NAVApp -ServerInstance BC200 -Name "QR Generator" -version 20.2.41144.41423

Sync-NAVApp -ServerInstance BC200 -Name "India GST" -version 20.2.41144.41423

Sync-NAVApp -ServerInstance BC200 -Name "India Gate Entry" -version 20.2.41144.41423

Sync-NAVApp -ServerInstance BC200 -Name "India TCS" -version 20.2.41144.41423

Sync-NAVApp -ServerInstance BC200 -Name "India TDS" -version 20.2.41144.41423

Sync-NAVApp -ServerInstance BC200 -Name "India Voucher Interface" -version 20.2.41144.41423

Sync-NAVApp -ServerInstance BC200 -Name "Fixed Asset Depreciation for India" -version 20.2.41144.41423

Sync-NAVApp -ServerInstance BC200 -Name "India Reports" -version 20.2.41144.41423

Sync-NAVApp -ServerInstance BC200 -Name "India Data Migration" -version 20.2.41144.41423

 

 

Sync-NAVApp -ServerInstance BC200 -Name "ABC_Client_HR_Development" -version 1.0.0.3

Sync-NAVApp -ServerInstance BC200 -Name "ABC_Client_Development" -version 1.0.0.4

Sync-NAVApp -ServerInstance BC200 -Name "Quality Control" -version 1.0.0.9

Sync-NAVApp -ServerInstance BC200 -Name "Purchase Indent" -version 1.0.0.5

Sync-NAVApp -ServerInstance BC200 -Name "EInvoice and Eway Bill Development ISPL" -version 1.0.0.1

 

Start-NAVDataUpgrade -ServerInstance BC200 -Tenant Default -FunctionExecutionMode Serial -SkipAppVersionCheck

 

Get-NAVDataUpgrade -ServerInstance BC200

 

Install-NAVApp -ServerInstance BC200 -Name "Application" -Version 20.2.41144.41423

Install-NAVApp -ServerInstance BC200 -Name "Company Hub" -Version 20.2.41144.41423

Install-NAVApp -ServerInstance BC200 -Name "Contoso Coffee Demo Dataset" -Version 20.2.41144.41423

Install-NAVApp -ServerInstance BC200 -Name "Data Archive" -Version 20.2.41144.41423

Install-NAVApp -ServerInstance BC200 -Name "Troubleshoot FA Ledger Entries" -Version 20.2.41144.41423

Install-NAVApp -ServerInstance BC200 -Name "Email - Outlook REST API" -Version 20.2.41144.41423

Install-NAVApp -ServerInstance BC200 -Name "Email - Microsoft 365 Connector" -Version 20.2.41144.41423

Install-NAVApp -ServerInstance BC200 -Name "Email - Current User Connector" -Version 20.2.41144.41423

Install-NAVApp -ServerInstance BC200 -Name "Email - SMTP API" -Version 20.2.41144.41423

Install-NAVApp -ServerInstance BC200 -Name "Email - SMTP Connector" -Version 20.2.41144.41423

Install-NAVApp -ServerInstance BC200 -Name "Essential Business Headlines" -Version 20.2.41144.41423

Install-NAVApp -ServerInstance BC200 -Name "Late Payment Prediction" -Version 20.2.41144.41423

Install-NAVApp -ServerInstance BC200 -Name "Universal Print Integration" -Version 20.2.41144.41423

Install-NAVApp -ServerInstance BC200 -Name "OnPrem Permissions" -Version 20.2.41144.41423

Install-NAVApp -ServerInstance BC200 -Name "Payment Links to PayPal" -Version 20.2.41144.41423

Install-NAVApp -ServerInstance BC200 -Name "Recommended Apps" -Version 20.2.41144.41423

Install-NAVApp -ServerInstance BC200 -Name "Sales and Inventory Forecast" -Version 20.2.41144.41423

Install-NAVApp -ServerInstance BC200 -Name "Send To Email Printer" -Version 20.2.41144.41423

Install-NAVApp -ServerInstance BC200 -Name "Simplified Bank Statement Import" -Version 20.2.41144.41423

Install-NAVApp -ServerInstance BC200 -Name "Permissions Mock" -Version 20.2.41144.41423

Install-NAVApp -ServerInstance BC200 -Name "Test Runner" -Version 20.2.41144.41423

Install-NAVApp -ServerInstance BC200 -Name "Performance Toolkit" -Version 20.2.41144.41423

 

 

Start-NAVAppDataUpgrade -ServerInstance BC200 -Name "Tax Engine" -version 20.2.41144.41423

Start-NAVAppDataUpgrade -ServerInstance BC200 -Name "India Tax Base" -version 20.2.41144.41423

Start-NAVAppDataUpgrade -ServerInstance BC200 -Name "India TCS" -version 20.2.41144.41423

Start-NAVAppDataUpgrade -ServerInstance BC200 -Name "India TDS" -version 20.2.41144.41423

Start-NAVAppDataUpgrade -ServerInstance BC200 -Name "India Voucher Interface" -version 20.2.41144.41423

Start-NAVAppDataUpgrade -ServerInstance BC200 -Name "Fixed Asset Depreciation for India" -version 20.2.41144.41423

 

Install-NAVApp -ServerInstance BC200 -Name "QR Generator" -version 20.2.41144.41423

Install-NAVApp -ServerInstance BC200 -Name "India Reports" -version 20.2.41144.41423

 

Start-NAVAppDataUpgrade -ServerInstance BC200 -Name "India GST" -version 20.2.41144.41423

Start-NAVAppDataUpgrade -ServerInstance BC200 -Name "India Gate Entry" -version 20.2.41144.41423

Start-NAVAppDataUpgrade -ServerInstance BC200 -Name "India Data Migration" -version 20.2.41144.41423

 

Start-NAVAppDataUpgrade -ServerInstance BC200 -Name "ABC_Client_HR_Development" -version 1.0.0.3

Start-NAVAppDataUpgrade -ServerInstance BC200 -Name "ABC_Client_Development" -version 1.0.0.4

Start-NAVAppDataUpgrade -ServerInstance BC200 -Name "Quality Control" -version 1.0.0.9

Start-NAVAppDataUpgrade -ServerInstance BC200 -Name "Purchase Indent" -version 1.0.0.5

Start-NAVAppDataUpgrade -ServerInstance BC200 -Name "EInvoice and Eway Bill Development ISPL" -version 1.0.0.1

 

$InstanceName = 'BC200'

$ServicesAddinsFolder = 'C:\Program Files\Microsoft Dynamics 365 Business Central\200\Service\Add-ins'

Set-NAVAddIn -ServerInstance $InstanceName -AddinName 'Microsoft.Dynamics.Nav.Client.BusinessChart' -PublicKeyToken 31bf3856ad364e35 -ResourceFile ($AppName = Join-Path $ServicesAddinsFolder 'BusinessChart\Microsoft.Dynamics.Nav.Client.BusinessChart.zip')

Set-NAVAddIn -ServerInstance $InstanceName -AddinName 'Microsoft.Dynamics.Nav.Client.FlowIntegration' -PublicKeyToken 31bf3856ad364e35 -ResourceFile ($AppName = Join-Path $ServicesAddinsFolder 'FlowIntegration\Microsoft.Dynamics.Nav.Client.FlowIntegration.zip')

Set-NAVAddIn -ServerInstance $InstanceName -AddinName 'Microsoft.Dynamics.Nav.Client.OAuthIntegration' -PublicKeyToken 31bf3856ad364e35 -ResourceFile ($AppName = Join-Path $ServicesAddinsFolder 'OAuthIntegration\Microsoft.Dynamics.Nav.Client.OAuthIntegration.zip')

Set-NAVAddIn -ServerInstance $InstanceName -AddinName 'Microsoft.Dynamics.Nav.Client.PageReady' -PublicKeyToken 31bf3856ad364e35 -ResourceFile ($AppName = Join-Path $ServicesAddinsFolder 'PageReady\Microsoft.Dynamics.Nav.Client.PageReady.zip')

Set-NAVAddIn -ServerInstance $InstanceName -AddinName 'Microsoft.Dynamics.Nav.Client.PowerBIManagement' -PublicKeyToken 31bf3856ad364e35 -ResourceFile ($AppName = Join-Path $ServicesAddinsFolder 'PowerBIManagement\Microsoft.Dynamics.Nav.Client.PowerBIManagement.zip')

Set-NAVAddIn -ServerInstance $InstanceName -AddinName 'Microsoft.Dynamics.Nav.Client.RoleCenterSelector' -PublicKeyToken 31bf3856ad364e35 -ResourceFile ($AppName = Join-Path $ServicesAddinsFolder 'RoleCenterSelector\Microsoft.Dynamics.Nav.Client.RoleCenterSelector.zip')

Set-NAVAddIn -ServerInstance $InstanceName -AddinName 'Microsoft.Dynamics.Nav.Client.SatisfactionSurvey' -PublicKeyToken 31bf3856ad364e35 -ResourceFile ($AppName = Join-Path $ServicesAddinsFolder 'SatisfactionSurvey\Microsoft.Dynamics.Nav.Client.SatisfactionSurvey.zip')

Set-NAVAddIn -ServerInstance $InstanceName -AddinName 'Microsoft.Dynamics.Nav.Client.SocialListening' -PublicKeyToken 31bf3856ad364e35 -ResourceFile ($AppName = Join-Path $ServicesAddinsFolder 'SocialListening\Microsoft.Dynamics.Nav.Client.SocialListening.zip')

Set-NAVAddIn -ServerInstance $InstanceName -AddinName 'Microsoft.Dynamics.Nav.Client.VideoPlayer' -PublicKeyToken 31bf3856ad364e35 -ResourceFile ($AppName = Join-Path $ServicesAddinsFolder 'VideoPlayer\Microsoft.Dynamics.Nav.Client.VideoPlayer.zip')

Set-NAVAddIn -ServerInstance $InstanceName -AddinName 'Microsoft.Dynamics.Nav.Client.WebPageViewer' -PublicKeyToken 31bf3856ad364e35 -ResourceFile ($AppName = Join-Path $ServicesAddinsFolder 'WebPageViewer\Microsoft.Dynamics.Nav.Client.WebPageViewer.zip')

Set-NAVAddIn -ServerInstance $InstanceName -AddinName 'Microsoft.Dynamics.Nav.Client.WelcomeWizard' -PublicKeyToken 31bf3856ad364e35 -ResourceFile ($AppName = Join-Path $ServicesAddinsFolder 'WelcomeWizard\Microsoft.Dynamics.Nav.Client.WelcomeWizard.zip')

 

Get-NAVApplication -ServerInstance BC200

Set-NAVApplication -ServerInstance BC200 -ApplicationVersion 20.2.41144.41423 -Force

 

Sync-NAVTenant -ServerInstance BC200 -Mode Sync -Tenant Default

 

Restart-NAVServerInstance -ServerInstance BC200

 

 

 

Start-NAVDataUpgrade -ServerInstance BC200 -FunctionExecutionMode Serial -Tenant Default

 

Get-NAVDataUpgrade -ServerInstance BC200

 

Set-NAVServerConfiguration -ServerInstance BC200 -KeyName SolutionVersionExtension -KeyValue "437dbf0e-84ff-417a-965d-ed2bb9650972" -ApplyTo All

 

Set-NavServerConfiguration -ServerInstance BC200 -KeyName "EnableTaskScheduler" -KeyValue true

 Restart-NAVServerInstance -ServerInstance BC200

Done....

You have migrated BC 14 to BC 20 Successfully.

Thank you for reading....

Keep Sharing...Keep Growing....

Merge Object Using Powershell (CU Update & NAV Upgrade)

Hello Friends,

Use the NAV Development Shell to auto merge the NAV Objects

It is very useful for

• CU Upgrade
• NAV Upgrade
• Bug Fix Merge
• Big/Small Functionality Merge

Suppose we take one example to install CU 17 to customer object having CU11

1) Create 4 Folder as shown in following snapshot.

2) Open NAV Development Shell using administrator and following script

Cmdlet: Merge-NAVApplicationObject -OriginalPath C:\Users\nishit\Desktop\Temp\Shyam\1Original\*.txt -ModifiedPath  C:\Users\nishit\Desktop\Temp\Shyam\2Modified\*.txt -TargetPath C:\Users\nishit\Desktop\Temp\Shyam\3Target\*.txt -ResultPath C:\Users\nishit\Desktop\Temp\Shyam\4Result\

3) System auto merge targe file and show the result, You need to solve conflict files

Done.

If you have query than write comments

Thank you for reading.

Keep Sharing..Keep Growing...

Dynamics NAV Upgrade from NAV 2013/ 2013 R2 to NAV 2018 Latest CU

Hello Friends,

If you want to upgrade a customer's database from Dynamics NAV 2013 or Dynamics NAV 2013 R2, you may have noticed that the latest Dynamics NAV 2018 cumulative update does not have a direct path to upgrade from these earlier versions.

Mainstream support end for NAV 2013 and 2013 R2, So there is no direct upgrade toolkit provided for NAV 2018 higher version than CU2.

In this article, we would discuss about Data Upgrade from NAV 2013 to NAV 2018 CU5 (Build 21836).

Microsoft Link for Data Upgrade to NAV 2018: MS DOCS

Task 1: Prepare the old database

1) Use the Microsoft Dynamics NAV 2013 Development Environment to build all application objects

2) Unlock all application objects

Filter - Locked True in object designer.

Select all Locked Objects and From File Select Force Unlock.

3) Synchronize the database schema by compiling all Objects

Task 2: Create a full SQL backup of the NAV 2013 database on SQL Server

Task 3: Uninstall all V1 extensions

As it is an NAV 2013 database there are no Extensions so skip this step.

Task 4: Upload the Microsoft Dynamics NAV 2018 license to the NAV 2013 database

- In the NAV 2013 development environment, on the File menu, point to Database, and then choose Alter.

- In the Alter Database window, choose Integration, and then select Save license in database.

- Restart Microsoft Dynamics NAV 2013 Server instance

Task 5: Delete all objects except tables from the NAV 2013 database

- Select All Objects in Object Designer and Mark All Objects.
- Select Tables in Object Designer, Select All and UN-mark all tables.
- From View Select Marked only and select all in Object Designer.
- Delete all Objects (marked Objects).

Task 6: Uninstall (optional) the old product (NAV 2013) and install the new product (NAV 2018 CU 5)

- Along with Installation of NAV 2018 CU 5, create a service for NAV 2018 CU 2
- Increase the SQL Command Time Out from 00:30:00 to 20:00:00 for both Services (One Service for NAV 2018 CU 2 and one Service for NAV 2018 CU 5)

Task 7: Clear Dynamics NAV Server instance and debugger breakpoints records from NAV 2013 database

1) Stop NAV 2013 Service

2) Using SQL Server Management Studio, open and clear the dbo.Server Instance and dbo.Debugger Breakpoint tables of the NAV 2013 database

DELETE FROM [NAV2018_TEST].[dbo].[Server Instance]

DELETE from [NAV2018_TEST].[dbo].[Debugger Breakpoint]

where NAV2018_TEST is my Databasename

Task 8: Convert the NAV 2013 database to the Microsoft Dynamics NAV 2018 CU 2 Database

- Open NAV 2018 CU 2 Developer Environment - Run as Administrator
- Open the NAV 2013 database in NAV 2018 CU 2 Development Environment
- Follow the conversion instructions
- Important: Do not run schema synchronization at this time.

Task 9: Import the upgraded application objects (NAV 2018 CU 2) and upgrade toolkit objects into the converted database

- Import Merged objects from NAV 2018 CU 2 Object Merge in the database. (Select Replace all)
- Do not run table synchronization (Select Later if asked)
- Import Upgrade Toolkit Objects (Upgrade7001100.fob) in Database
- Do not run table synchronization (Select Later if asked)

Task 10: Connect a Microsoft Dynamics NAV 2018 CU 2 Server instance to the converted database

- Connect to NAV 2018 CU 2 service that we created in Task 6

Task 11: Compile all objects that are not already compiled

- Filter Objects with compiled false.
- Compile objects with Synchronization Schema Later.

If you get errors on the following table objects, use the Object Designer to delete the objects because they are no longer used.

Table 470 Job Queue (replaced by the Task Scheduler)
Table 824 DO Payment Connection Details
Table 825 DO Payment Connection Setup
Table 827 DO Payment Credit Card
Table 828 DO Payment Credit Card Number
Table 829 DO Payment Trans. Log Entry
Table 1510 Notification Template

When you delete following table object, in the Delete confirmation dialog box, set the Synchronize Schema option to Force. 

- Test Runner Codeunits
Codeunit - 130400 - CAL Test Runner
Codeunit - 130402 - CAL Command Line Test Runner

OnBeforeTestRun - Verify parameter FunctionTestPermissions

OnAfterTestRun - Verify parameter FunctionTestPermissions

Task 12: Run the schema synchronization on the imported objects - NAV 2018 CU 2

From Tools - Sync. Schema for all Tables - With Validation

Task 13: Run the data upgrade process - NAV 2018 CU 2

- Open NAV 2018 CU 2 Development Environment as an administrator. 
- On the Tools menu, choose Data Upgrade, and then choose Start and follow the instructions. 
- To view the progress of the data upgrade, on the Tools menu, choose Data Upgrade, and then choose Show Progress. 

Below Tasks A to I are for NAV 2018 CU 2 ==> NAV 2018 CU 5

Microsoft Link: https://docs.microsoft.com/en-us/dynamics-nav/upgrading-to-microsoft-dynamics-nav

Task A: Create a full SQL backup of the NAV 2018 CU 2 database on SQL Server

Task B: Stop NAV 2018 CU 2 Service

Task C: Convert the NAV 2018 CU 2 database to the Microsoft Dynamics NAV 2018 CU 5 Database

- Open NAV 2018 CU 5 Developer Environment - Run as Administrator
- Open the NAV 2018 CU 2 database in NAV 2018 CU 5 Development Environment
- Follow the conversion instructions
- Important: Do not run schema synchronization at this time.

Task D: Import the upgraded application objects (NAV 2018 CU 5) into the converted database

- Import Merged objects from NAV 2018 CU 5 Object Merge in the database. (Select Replace all)
- Do not run table synchronization (Select Later if asked)
- Do not run table synchronization (Select Later if asked)

Task E: Connect a Microsoft Dynamics NAV 2018 CU 5 Server instance to the converted database

- Connect to NAV 2018 CU 5 service that we created in Task 6

Task F: Compile all objects that are not already compiled

- Filter Objects with compiled false.
- Compile objects with Synchronization Schema Later.

Task G: Run the schema synchronization on the imported NAV 2018 CU 5 objects

From Tools - Sync. Schema for all Tables - With Validation

Task H: Run the data upgrade process - NAV 2018 CU 5

- Open NAV 2018 CU 5 Development Environment as an administrator. 
- On the Tools menu, choose Data Upgrade, and then choose Start and follow the instructions. 
- To view the progress of the data upgrade, on the Tools menu, choose Data Upgrade, and then choose Show Progress. 

Task I: Create a full SQL backup of the NAV 2018 CU 5 database on SQL Server

Task 14: Import upgraded permission sets and permissions by using the Roles and Permissions XML ports

Task 15: Set the language of the customer database

In the development environment, choose Tools, choose Language, and then select the language of the original customer database.

Task 16: Register client control add-ins

- To use these add-ins, they must be registered in table 2000000069 Client Add-in.

Microsoft.Dynamics.Nav.Client.BusinessChart 

Microsoft.Dynamics.Nav.Client.DynamicsOnlineConnect

Microsoft.Dynamics.Nav.Client.FlowIntegration

Microsoft.Dynamics.Nav.Client.OAuthIntegration

Microsoft.Dynamics.Nav.Client.PageReady 

Microsoft.Dynamics.Nav.Client.PingPong 

Microsoft.Dynamics.Nav.Client.SocialListening 

Microsoft.Dynamics.Nav.Client.TimelineVisualization

Microsoft.Dynamics.Nav.Client.VideoPlayer 

Microsoft.Dynamics.Nav.Client.WebPageViewer

Task 17: Publish and install/upgrade extensions

Database = nav2018_test

Server Instance = nav2018_test

Database Server = NAVDB

You can find Extensions in NAV 2018 CU 5 DVD ==> ..\NAV.11.0.21836.W1.DVD\Extensions\

My Folder Path = C:\Prerequisites\Extensions\

You can download Microsoft_Application_11.0.19738.0.app using below link
Microsoft_Application_11.0.19738.0.app

You can find ModernDev in NAV 2018 CU 5 DVD 
..\NAV.11.0.21836.W1.DVD\ModernDev\program files\Microsoft Dynamics NAV\110\Modern Development Environment

My Folder Path = C:\Prerequisites\Extensions\ModernDev\

1) Open Microsoft Dynamics NAV Administration Shell - Run as Administrator

Run below commands:

Publish-NAVApp -ServerInstance nav2018_test -Path "C:\Prerequisites\Extensions\ModernDev\System.app" -PackageType SymbolsOnly

Publish-NAVApp -ServerInstance nav2018_test -Path "C:\Prerequisites\Extensions\ModernDev\Test.app" -PackageType SymbolsOnly

Publish-NAVApp -ServerInstance nav2018_test -Path "C:\Prerequisites\Extensions\ModernDev\Microsoft_Application_11.0.19738.0.app" -PackageType SymbolsOnly

2) Update Custom Setting file parameter "EnableSymbolLoadingAtServerStartup" = True

3) Restart Microsoft Dynamics NAV 2018 CU 5 Server instance

4) Generate the application symbol references for running Running C/SIDE and AL Side-by-Side

5) Open command prompt - Run as Administrator

Run below command:

cd "C:\Program Files (x86)\Microsoft Dynamics NAV\110\RoleTailored Client"

finsql.exe Command=generatesymbolreference, Database=nav2018_test, ServerName=NAVDB

Verify results after 5 minutes at location

C:\Program Files (x86)\Microsoft Dynamics NAV\110\RoleTailored Client\navcommandresult.txt

"[0] [07/07/18  3:08:25 AM] The command completed successfully in '268' seconds."

6) V1 extensions have the file type .navx. V2 extensions have the file type .app

7) Open Microsoft Dynamics NAV Administration Shell - Run as Administrator

Run below commands:

For V1 Extensions:

Publish-NAVApp -ServerInstance nav2018_test -Path "C:\Prerequisites\Extensions\Ceridian.navx"

Publish-NAVApp -ServerInstance nav2018_test -Path "C:\Prerequisites\Extensions\MSWalletPayments.navx"

Publish-NAVApp -ServerInstance nav2018_test -Path "C:\Prerequisites\Extensions\PayPalPaymentsStandard.navx"

Publish-NAVApp -ServerInstance nav2018_test -Path "C:\Prerequisites\Extensions\QuickBooksDataMigration.navx"

Publish-NAVApp -ServerInstance nav2018_test -Path "C:\Prerequisites\Extensions\QuickbooksPayrollFileImport.navx"

Publish-NAVApp -ServerInstance nav2018_test -Path "C:\Prerequisites\Extensions\SalesAndInventoryForecast.navx"

For V2 Extensions:

Publish-NAVApp -ServerInstance nav2018_test -Path "C:\Prerequisites\Extensions\C52012DataMigration.app"

Publish-NAVApp -ServerInstance nav2018_test -Path "C:\Prerequisites\Extensions\ImageAnalysis.app"

For V2 Extensions - Sync

Sync-NAVApp -ServerInstance nav2018_test -Name "C5 2012 Data Migration" -Version 1.0.21836.0

Sync-NAVApp -ServerInstance nav2018_test -Name "Image Analyzer" -Version 1.0.21836.0

Task 18: Update the Dynamics NAV Web client configuration file (navsettings.json)

If you have installed the Microsoft Dynamics NAV Web Server components, populate the navsettings.json file for the Dynamics NAV Web Server instance with the settings of the NAV 2013 web.config file.

NAV 2013 - web.config file

NAV 2018 CU 5 - NAVSettings.JSON file

Task 19: Delete the upgrade objects

- At this point, we have upgraded the database to Microsoft Dynamics NAV 2018 CU 5. 

- Now, you can delete the upgrade codeunits and upgrade table objects that you imported in task 9. This task is recommended but not required.

- Filter Objects with Version Tag - UPGTK11.00.00 and delete objects with Force

I hope this would help you a lot. Please also let me know your views.

let write the comment if you need any help.

Keep Sharing... Keep Growing...