NAV 2013 and Sql Server 2012

(0) Share

Report

Posted on by Community Member

Is there a tool in SQL Server that would show the relationships between tables in NAV 2013? I'm wanting to track a specific field from one table to the next to the next. My NAV expert does not see this information in Object Explorer.

*This post is locked for comments

I have the same question (0)

All responses (4)

Answers (2)

Suggested answer

Community Member on at

Like (1)

Report

Hi,

Check this tool.... This should help you to find your answer.

community.dynamics.com/.../182841

Regards,

Vishal Salot

//If this answer helps you, pl. mark this as verified.

Was this reply helpful? Yes No
Suggested answer

Suresh Kulla 50,243 Super User 2025 Season 2 on at

Like (0)

Report

You can use a a where used functionality in this tool http://www.stati-cal.com/ but you need to have developer license to convert the objects into text.

Was this reply helpful? Yes No
Verified answer

Tharanga Chandrasekara 23,118 on at

Like (0)

Report

With Dynamics NAV database you do not have the luxury of building a diagram which will illustrate the table relationship. However from Dynamics NAV development environment side you can extract the object files to a text and analyze using Statical Prism tool. To get the full use of it you might have to purchase it.

http://www.stati-cal.com/

Was this reply helpful? Yes No
Verified answer

keoma 32,729 on at

Like (0)

Report

you can use

statical prism: www.stati-cal.com/learn.html

OM Tools: www.idyn.nl/.../object-manager-advanced

also have a look at

www.g-d-t.de/download.htm

mibuso.com/.../dynamics-nav-object-text-explorer-v1.0.0.31

www.tfsfordynamicsnav.com/support

Was this reply helpful? Yes No