Corresponding Table in Object Designer and Database (Mysql)

DLLT_eys
DLLT_eys Member Posts: 8
edited 2011-11-25 in NAV Three Tier
Hey,

How can I easily find the corresponding table in the Mysql databse when I'm looking at Navision. I assume I should be looking in the object designer under Table?

Thxs

Edit: Some extra info: i'm using Nav 2009 R2 and SQL Server 2008 R2

Comments

  • einsTeIn.NET
    einsTeIn.NET Member Posts: 1,050
    Most of the tables in NAV are set to DataPerCompany = Yes. That means in SQL they have the company name infront of their real name (CompanyName$TableName).

    Additionally some special characters of a NAV table's name are converted into another character in SQL (default value is underscore _). That means if you have a table in NAV called e.g. "Cust. Ledger Entry" then in SQL Server it would be something like this "CompanyName$Cust_ Ledger Entry".

    If you keep that in mind then you should be able to find your tables in the Object Designer filtered on Table.
    "Money is likewise the greatest chance and the greatest scourge of mankind."
  • David_Singleton
    David_Singleton Member Posts: 5,479
    Navision does not run on MySQL.
    David Singleton

Categories