Database Schema Diagram

senthil

Hi,

Is Database Schema diagram avilable for Navision 4.0, SP1?
I am working on reports. I am trying to create reports in a repoting tool for the SQL Server option database. So it is difficult to prepare reports without knowing the DB Schema diagram. Is it possible to get.

Luc_VanDyck

There are some tools in the Download section of this website: http://www.mibuso.com/downloads . Or you can have a look at www.navitools.com which has developed some db diagrams.

colin_leversuch-roberts

sql server contains default ability to produce database diagrams - it's not the world's best diagram tool but it's free and it works.
Navision sadly doesn't seem to have any RFI so you'll not get any relationships shown on the diagram.
If you have visio this can reverse engineer a sql server database and provides additional functionality, depending upon the version used.
I've evaluated DeZign with sql server 2000 and 2005 and it's well featured and much cheaper than the big tools.

http://www.datanamic.com/dezign/index.html

kine

You can enable the RFI in File - Database - Alter - Integration menu, but still, because some fields in NAV can have multiple relations based on some option (e.g. Type and No. field in Sales Line) SQL is not able to create such a diagram, because NAV has wider possibilities than SQL. SQL can create diagram just for the simple relations, but same info you can read from FIELD table in NAV.