The earlier versions of the Microsoft Dynamics NAV supported either Microsoft’s SQL server or a native DBMS. However, the NAV 2013 supports only the Microsoft SQL server. The dynamics NAV ERP system allows simultaneous access to the application by multiple users. As the number of users increased, so did the possibility of data collision and database locking. With the usage of Microsoft’s SQL server, such resource collisions are drastically reduced. It renders it possible to use MS Excel PowerPivot to access data and present the reports customised as preferred by the customer. Metaphorix sells dynamics nav in UK.
The usage of MS SQL also provides command line utilities that enable creating and manipulating the databases directly and quickly.
Indeed, SQL is the soulmate for the NAV!