Upgrade Nav 2017 to BC 14 with custom Extension : Issue Archived Data not restored

jayanta.sadhu · 2020-07-30

I'm working on migration of NAV 2017 DB with (Extension XYZNAVX Version 1.0.0.0 installed in it) to BC14

Steps I followed as per the guidelines https://docs.microsoft.com/en-us/dynamics365/business-central/dev-itpro/upgrade/upgrading-the-data

As a prerequisite I prepared app file XYZAPP version 2.0.0.0 using VS Code that is similar to XYZNAVX Version 1.0.0.0 with same name same app id. Upgrade Codeunit is there with triggers per Company Per Database

Steps followed

1. Uninstalled all extensions from NAV 2017 DB

2. Dismounted Tenant

3. Change BC Licence

4. Stop the service

5. Delete all objects except Tables

6. Convert DB to using BC 14

7. Imported Upgrade Toolkit Objects and BC 14 application object

8. Connected to BC 14 instance

9. Mounted Tenant DB

10. Run Sync-NAVTenant

11. Start-NavDataUpgrade

12. Published and Sync-NAVApp System and Test app

13. Used finsql to generatesymbolreference using command promt

14. Published XYZAPP version 2.0.0.0

15. SyncNavapp XYZAPP version 2.0.0.0

While try to run Start-NAVAppDataUpgrade error appeared Previous extension is not present. (Though XYZNAVX version still there. Archived data still present in SQL for the old extension

15. Used Install-NAVApp XYZAPP version 2.0.0.0 . I can see fields related to App file in the DB but without Data

Could you please let me know if I missed any steps?

kylehardin · 2020-07-31

Start-NAVAppDataUpgrade runs upgrade codeunits. But since you don't have an old version of the app since this was all C/AL before, I think you are going to have to write your own data migration tool and run them manually. So skip Start-NAVAppDataUpgrade, and just run your own migration tool.

https://docs.microsoft.com/en-us/powershell/module/microsoft.dynamics.nav.apps.management/start-navappdataupgrade?view=businesscentral-ps-16

jayanta.sadhu · 2020-08-01

Thank you very much Kylehardin. I was going through the below link related to Converting Extensions V1 to Extensions V2.

https://docs.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/devenv-upgrade-v1-to-v2-overview

In the section Run the upgrade below steps have been mentioned

1. Uninstall the V1 extension.
(not sure how v1 was installed in BC version)

2. Publish the V2 extension.

3. Synchronize the V2 extension with the database.

4. Start-NAVAppDataUpgrade -ServerInstance NAV -Name ProswareStuff -Version 1.5.1.0

5. Unpublish-NAVApp -ServerInstance NAV -Name ProswareStuff -Version 1.5.0.0

I followed all the steps but data are not restored from V1 extension to V2 Extension Tables. May be I missed something

Upgrade Nav 2017 to BC 14 with custom Extension : Issue Archived Data not restored

Answers

Categories