Navision Database Schema

lot
lot Member Posts: 3
in NAV/Navision Classic Client
Can sombody help me of how to view the navision 2005 database schema
Thanks.

Answers

  • Slawek_Guzek
    Slawek_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
  • thomasbarbut
    thomasbarbut 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
  • vaprog
    vaprog Member Posts: 1,163
    Also Check out @Kine's The Big Picture of NAV
  • kennie
    kennie 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

Categories