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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / How to identify NAV cu...
Small and medium business | Business Central, N...
Suggested Answer

How to identify NAV cumulative update version from a .bak database?

(3) ShareShare
ReportReport
Posted on by TAHER_El_Mehdi 889

Hi everyone,

I’m working on an upgrade project for a customer using Microsoft Dynamics NAV 2016, and I’ve only been provided with a .bak database backup.

Before proceeding, I’d like to determine which cumulative update (CU) version the database is on, so I can install the appropriate NAV version for compatibility.

Is there a way to identify the exact NAV 2016 version or CU directly from the SQL database?

For example, are there specific tables or fields (like build number or version) that I should check?

Any guidance or best practices would be greatly appreciated.

Thanks in advance!

Categories:
Microsoft Dynamics NAV
Dynamics 365 Business Central migration
I have the same question (0)
  • Suggested answer
    OussamaSabbouh Profile Picture
    OussamaSabbouh 13,843 Super User 2026 Season 1 on at
    Hello,
    You usually can get close enough directly from SQL, and the best thing to look for is the application build number stored in the NAV database, then match that build to Microsoft’s NAV 2016 CU list. The simplest place to check is typically the [$ndo$dbproperty] table after restoring the backup to SQL; that table usually contains version/build information for the database/application. Once you get the 9.0.xxxxx build, compare it to Microsoft’s NAV 2016 cumulative update build overview to identify the CU. If for some reason that table doesn’t give you what you need, the next practical method is to inspect object metadata/version list patterns in SQL, but build number from database properties is the cleanest route. So the workflow is basically: restore .bak → query db property/build → map build to NAV 2016 CU.
     
    Regards,
    Oussama Sabbouh
  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 99,602 Super User 2026 Season 1 on at
    I don't remember the exact table name, but you can restore the database first, and then you can find the build number in a table like $ndo$dbproperty.
     
    Hope this can give you some hints.
    Thanks.
    ZHU

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,065 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 1,132 Super User 2026 Season 1

#3
Khushbu Rajvi. Profile Picture

Khushbu Rajvi. 703 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans