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) / Navision and SQl compa...
Microsoft Dynamics NAV (Archived)

Navision and SQl compatibility Matrix sheet ?

(0) ShareShare
ReportReport
Posted on by Marshal 440

Hi all,

Can any one suggest me where I can get NAV and SQL compatibility matrix

 

Thanks

Marshal 

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    keoma Profile Picture
    keoma 32,729 on at

    hi,

    i'm not sure what you mean, but maybe you wanna know how to find the nav tables within the sql db. the data tables have the same name as in nav, but with the company name as prefix except the base tables (users, security, ...).

    cheers

  • Tharanga Chandrasekara Profile Picture
    Tharanga Chandrasekara 23,118 on at

    Please be more specific.

  • Marshal Profile Picture
    Marshal 440 on at

    Hi,

    I want to check NAV 5.0 and 5.0SP1 is compatible with SQL Sever 2008 Express edition,

    Thanks

    Marshal

  • Verified answer
    Jens Glathe Profile Picture
    Jens Glathe 6,092 on at

    Hi Marshal,

    NAV 5.0 - compatible with SQL Server 2000, 2005, 2008

    NAV 5.0 SP1 - compatible with SQL Server 2005, 2008

    Reference: blogs.msdn.com/.../sql-server-trace-flag-4616-no-longer-required-for-dynamics-nav-2009-sp1.aspx

    with best regards

    Jens

  • SeverGr Profile Picture
    SeverGr 5 on at

    Dear all,

    Does anyboy know if NAV 5.0 SP1 is compatible with SQL Server 2014?

    Thanks for your answers.

  • Suggested answer
    Tharanga Chandrasekara Profile Picture
    Tharanga Chandrasekara 23,118 on at

    It does not support to 5.0

    Only NAV 2009 SP 01 on wards support SQL 2012

    Please refer below link : blogs.msdn.com/.../compatibility-update-with-microsoft-sql-server-2012.aspx

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