web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Suggested Answer

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

(0) ShareShare
ReportReport
Posted on by 10

I'm working 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?

I have the same question (0)
  • Suggested answer
    THE Italian Profile Picture
    on at

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

    But without knowning any context here, if I were you, I would move the extension data to a C\AL Table in NAV 2017 and then move it to the AL extension afterwards in BC 14.

    Something like

    a. Move Extension table data from extension to C/AL table data in NAV 2017 like. e.g. TEMPtableName (e.g. TEMPCustomer, TEMPitem)

    b.Unpublish with clean option the extension in NAV 2017 to completely clean up sql tables and metadata

    c. Perform a normal upgrade

    d. When in BC 14.x, publish your AL Extension with the tables you need and with a procedure that populate tables from TEMPxxx using transferfields

    e. Delete the TEMP object with force.

  • Jayanta Sadhu Profile Picture
    10 on at

    Thank you DUILIO TACCONI for the solution.

    Just to update you I have already gone though the document  docs.microsoft.com/.../devenv-upgrade-v1-to-v2-overview.

    As per step 5 when I'm using Start-NAVAppDataUpgrade -ServerInstance NAV -Name XYZAPP -Version 2.0.0.0 I'm getting below error,

    Cannot upgrade the extension 'XYZ by ABC 2.0.0.0' because no previous version was found.

    Please note that I'm still having same old extension XYZNAVX version 1.0.0.0 in the database. AppID and name is same in V1 and V2.

    Just to summarize the issue during migration

    1. I have un-installed extension from 2017 DB (NAVX) ,

    2. Published and sync-navapp completed in converted BC 14 (CU 14).

    3. Start-NAVAppDataUpgrade is not working with error no previous version was found

    4. Even I install V2 data not restored from old extension. in New app I have upgrade codeunit as mentioned in the link

    5. Data still Archived in SQL DB. Example : $AppData$AppID

    Regards

    Jayanta Sadhu

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,238

#2
YUN ZHU Profile Picture

YUN ZHU 773 Super User 2025 Season 2

#3
Sumit Singh Profile Picture

Sumit Singh 630

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans