Navision Database Schema

Can sombody help me of how to view the navision 2005 database schema
Thanks.

Answers

  • Slawek_GuzekSlawek_Guzek Member Posts: 1,690
    edited 2017-09-07
    I have tried this once, when I have just started my NAV career. I have enabled Maintain Relationships option on the database, and asked SQL Server Managament Studio (or perhaps an Enterprise Manager) to build a schema diagram for me.

    I have interrupted the process after some 8 hours. The results were completely unreadable.

    The reason was that NAV was too large then. It had 700+ tables then, most with with many relations, and also a conditional relations (a thing which is not supported in SQL server)

    Now standard NAV includes about 1100 tables..

    Slawek
    Slawek Guzek
    Dynamics NAV, MS SQL Server, Wherescape RED;
    PRINCE2 Practitioner - License GR657010572SG
    GDPR Certified Data Protection Officer - PECB License DPCDPO1025070-2018-03
  • thomasbarbutthomasbarbut Member Posts: 25
    Hello,

    this is for an older version.
    https://drive.google.com/file/d/0B0_cco-Kvw9Cei1MY0tycGk3VjA/view

    or check this thread
    https://community.dynamics.com/nav/f/34/t/122994

    I think the an ER-Diagram won't answer your Questions. You will have to start using Dynamics to really understand it.

    best regards,
    Thomas Barbut
  • vaprogvaprog Member Posts: 1,116
    Also Check out @Kine's The Big Picture of NAV
  • kenniekennie Member Posts: 34
    Also, foreign key constraints in the Dynamics NAV database are enforced by the platform, not SQL Server. This is not helping when generating ER diagrams in SSMS
Sign In or Register to comment.