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) / How to upgrade NAV ten...
Microsoft Dynamics NAV (Archived)

How to upgrade NAV tenant to 2016

(0) ShareShare
ReportReport
Posted on by MadsG

Hi,

I have a question about how to upgrade a NAV tenant to new version. Tenant versions are 2014 and 2015.
I need to run the data upgrade toolkit on the tenant DB, to make sure new tables and fields is published with correct data. What about obsolete tables, can the process delete these tables automatic?

But what is the process? And how to I optimize the task to be as quick as possible ( I have about 30 tenant DB's to upgrade).

Thank you.

//Mads

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Mohana Yadav Profile Picture
    Mohana Yadav 60,993 Super User 2025 Season 2 on at

    first create a test environment and then perform below steps

    1. you have to merge the changes done in NAV2015 to NAV2016.

    2. Prepare a final set of NAV2016 objects (we have to manually delete obsolete tables)

    3. Import Upgrade toolkit from NAV2016 DVD

    4. Above steps should be performed only when single tenant is mounted to application.

    5. try to sync the tenant. if there are any sync issues then you have to solve in the upgrade codeunit or create a new upgrade codeunit as per your customizations if required.

    6. if you can sync one tenant means all remaining tenants can be synched without any problem.

  • MadsG Profile Picture
    MadsG on at

    Hi,

    I have the standard NAV 2016 DB with imported upgrade objects. It is used as a multitenant APP database. Service is running fine.

    Now I take my 2015 tenant and mount. When I try dataupgrade it says, that database is not upgraded, so I need to run sync-navtenant.

    I can do that and then run dataupgrade, but will that work? Example in table Unit of meassure i have a danish field, which is now standard. But will sync not just delete old field, and create new without moving data ind dataupgrade toolkit?

    //Mads

  • Suggested answer
    Mohana Yadav Profile Picture
    Mohana Yadav 60,993 Super User 2025 Season 2 on at

    It wont move data to standard field.

    you have to write code in upgrade codeunit to move data from custom field to standard field.

    before that you have to store the data in a temp table, if your latest version of object didn't have custom field.

    Don't use force option ever. it will delete the data in deleted fields

  • MadsG Profile Picture
    MadsG on at

    Hi again Mohana,

    You don't quite answer my question, so I'll try to describe my situation.

    I have NAV multitenant solution running with multiple tenants on version 2015 CU 4. I want to move them to new server and NAV 2016 CU1.

    I have a server I run as a middle station between old and new NAV server.

    On middle server I have NAV 2016 Cu1 running multitenancy, and with upgrade objects in database.

    Only modifications are reports no table modifications.

    My plan is to do the following:

    1: Dismount and back up tenant db on old server

    2: Restore db on middle station server

    3: Mount and Upgrade tenant db

    4: Dismount and backup tenant db and restore on new server

    So what do I do in number 3?

    When I mount and try to run dataupgrade, I get meassage that I cannot do that because version of db is older than app database. Only option is to run Sync-Navtenant and then upgrade.

    I have tried that approach to do Sync (without force), then upgrade. And data seems to be moved correctly from/to old obsolete fileds to new fields.

    I am just pulsed why this works. Would the sync not throw away old data, so my dataupgrade do not have anything to move?

    I have testet with table 204 Unit of measure. In DK local version we had a field containing the data which is now in standard W1 as field id 3 - International unitcode. The old field data is moved correct to new field.

    Thanks

    //Mads

  • Verified answer
    Mohana Yadav Profile Picture
    Mohana Yadav 60,993 Super User 2025 Season 2 on at

    if you look at Upgrade codeunit then code will be there to move data from old field to new file din table 204.

    If you don't have any those kind of changes in your customizations then you can sync and mount tenant. Data will be moved properly.

  • MadsG Profile Picture
    MadsG on at

    Hi again,

    So the sync will do dataupgrade automatic, without me needing to run dataupgrade manually?

    What about upgrade tables?

    Will I need to delete them after, and sync tenant once again (deleting the tables in tenant db)?

  • Suggested answer
    Mohana Yadav Profile Picture
    Mohana Yadav 60,993 Super User 2025 Season 2 on at

    Sync will execute functions with type "TableSyncSetup"

    Generally it is used to copy data from master tables to Temp tables.

    Tools-->Dataupgrade-->Start will execute functions with Type UpgradePerCompany/UpgradePerDatabase etc.

    generally these are used to copy data from temp tables to master tables with diff. field no. etc.

    Please go through this video

    www.youtube.com/watch

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