Introduction

NAV was introduced with a proprietary database management system. All the information was stored in a flat file, which is called as FDB (Financial Database). With new versions, Microsoft added a second option, that is, SQL Server. FDB was supported until Version 2009 R2. From NAV 2013, SQL Server is the only database option for NAV.

With the SQL Server, we get better options to maintain, secure, optimize, and analyze the data; these options make the SQL Server a very important part of the NAV system. Considering this, Microsoft added a mandatory certification for every partner on SQL Server implementation and maintenance.

In this chapter we will learn some of the basic activities, which all developers need to know while developing NAV 2013.