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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / Data migration & C...
Microsoft Dynamics NAV (Archived)

Data migration & Config. Package Transferring Data from NAV 2009 to NAV 2016

(0) ShareShare
ReportReport
Posted on by Binesh 7,885

Hello experts,

I'm exporting data from NAV 2009 using Data migration, in excel format.

See the bellow screenshot

3582.E2xl-2009.png

After successfully exported, I'm going to Import in NAV 2016 using Config. Package Card,

See the bellow screenshot

Import-from-XL-2016.png

But i'm getting error, why because, in NAV 2016 XML Schema has been changed, and added one more element PackageCard.

How could i import data from excel in NAV 2016 using Config Package Card.

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Rabin Profile Picture
    Rabin 2,976 on at

    Hi Binesh,

    Why don't you first export the Template from NAV 2016 (using CP) and fill the data you have from NAV 2009 and import again into 2016. Its worked for me.

    Hope it works for you as well.

  • Suggested answer
    Suresh Kulla Profile Picture
    Suresh Kulla 50,243 Super User 2025 Season 2 on at

    Try to export the data from 2016 first to get the excel file and then copy over the data from your 2009 excel file to the new NAV 2016 Excel and use that for import.

  • Verified answer
    Binesh Profile Picture
    Binesh 7,885 on at

    Thank you Rabindra & Suresh for your response.

    Data transferring is not a problem, we have many alternate solution like

    SQL Server DB->Tasks->Export Data... here our BLOB field also transferred.

    actually i need a generic solution. so we can copy/transfer multiple tables data at a time.

    for that i made changes in bellow objects.

    -----Upgrade need in NAV 2009-----

    XMLPort 8610  Setup Data Schema in this i added the PackageCode like NAV 2016.

    and added "Package Code" field in Migration Table[8614], Migration Table Field[8616].

    Codeunit Migration Management[8611] in that we have to update the functions

       ExportSetupDataToExcel

       ExportSetupDataXML

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…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans