Hello everyone,
I want to know what are the main database schema changes between NAV 4.0 and NAV 2016. If have document or ideas please kindly share it with me.
Thank you in Advance.
Dushan.
*This post is locked for comments
I do not think there would exist such direct comparison. It is possible to figure that out, but it depends on your final need. why do you need this?
You can refer more to the main table descriptions: msdn.microsoft.com/.../hh893827(v=nav.90).aspx
Please check this thread:
forum.mibuso.com/.../all-table-relations-from-nav
This technical architecture overview might also be helpful: www.diku.dk/.../hvitved09tr.pdf
As Rabindra said there is no Schema diagrams available for Dynamics NAV. What you can do is export all the objects to text format and then compare it with a tool. However I really doubt about outcome of it since it will be a very tiring work. 4.0 --> 2016 is lot of versions and you might found completely different tables in NAV 2016.
If you can let us know the requirement behind this then we might be able to propose you a workaround.
Hi Dushan,
First of all there is no Schema for NAV 4.0... But you can create schema type diagram on paper with the help of table relations.
The older NAV version(4.1) had its own DB and NAV 2016 uses MS SQL Server DB.
If you want to know the differences between NAV 4.0 and NAV 2016 then probably you can find lots of papers and blogs on the topic and that is how you can compare the Database level difference as well...
------------------
Hi Dushan,
I've never seen a technical document describing such details. By the way what is the requirement ?
The closest thing you can do from NAV is export all table objects to a .TXT file from both versions, and compare them using a text comparison tool like Araxis Merge.
From SQL side you can always try script table schemas, views and SPs to a text file and then do a text comparison.
Hope this helps.
Chaminda.
No one have information?
#1
André Arnaud de Cal...
292,516
Super User 2025 Season 1
#2
Martin Dráb
231,401
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
