Upgrade V2 Extension Data From Navision 2018 To Business Central On Premises

1) Create Extension for customization.

For e.g. I have created new field “Test UPG” in Sales header extension and a new table

2) Create package and publish it in Dynamics Navision 2018 and fill the data.

3) Upgrade Process is as follows:

• Open ISE as administrator and import NAV 2018 admin tool.Import-Module ‘C:\Program Files\Microsoft Dynamics NAV\90\Service\NavAdminTool.ps1’.
• Check whether v1 extensions exist. For this run command

Get-NAVAppInfo -ServerInstance demo2016.

IF EXIST THEN RUN

Uninstall-NAVApp -ServerInstance DEMO2016 -Name <Name> -Version <N.N.N.N>.

• Upload BC license into Nav 2018.
• Delete all objects from 2018 except the tables.

 And

         Clear server instance and debugger breakpoint records from the NAV 2018 DB.

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

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

        OR

Set-NAVServerInstance –ServerInstance <ServerInstanceName> -Stop (in ISE)

• Open BC (As administrator) and convert Navision 2018 DB in bc. Compile the Objects -> with later.
• Connect a Dynamics 365 Business Central Server instance to the converted database
• Recompile V2 extensions that you uninstalled previously

Get-NAVAppInfo –ServerInstance <ServerInstanceName> | Repair-NAVApp.

• Run the schema synchronization with validation to complete the database conversion.
• Increase the application version of the database (Applies if Upgrading from NAV 2018)

If you are upgrading from Microsoft Dynamics NAV 2018, you must increase the application version that is assigned to the database.

Use the Set-NAVApplication cmdlet of the Business Central Administration Shell to increase the application version number of the database from its current version.

To see the current version, use the following command:

Get-NAVApplication –ServerInstance <ServerInstanceName>

To change the version, use the following command:

Set-NAVApplication -ServerInstance <ServerInstanceName> -ApplicationVersion <N.N.N.N> -Force

• Run the schema synchronization on the imported objects.

          Sync-NavTenant -serverInstance

         Copy the error and resolve them.

• Import upgrade objects.

          upgrade toolkit -> local objects.

• Sync with Validation.
• Run Data upgrade

          Tools->Data upgrade-> start and resolve the error simultaneously and continue the same process.

• Install the app

          Install-NAVApp -ServerInstance -Name -Version .

https://docs.microsoft.com/en-us/dynamics365/business-central/dev-itpro/upgrade/converting-a-database

Disclaimer– “All data and information provided on this blog is for informational purposes only. Dynamics Square / MPG Business Information Systems Pvt. Ltd. makes no representations as to accuracy, completeness, currentness, suitability, or validity of any information on this site and will not be liable for any errors, omissions, or delays in this information or any losses, injuries, or damages arising from its display or use.”