Microsoft Dynamics NAV includes the finsql.exe file that enables you to perform certain tasks from a command prompt. The finsql.exe is an executable file that runs the development environment. By default, finsql.exe is located at C:\Program Files (x86)\Microsoft Dynamics NAV\80\RoleTailored Client\.
The finsql.exe has several commands that you can use to perform the tasks that are described in the following table:
Regenerates C# and metadata information for virtual tables in a specified database.
Create a new Microsoft Dynamics NAV database.
Upgrades the specified Microsoft Dynamics NAV database on the specified server.
Compile Microsoft Dynamics NAV objects from a specified database.
Delete Microsoft Dynamics NAV objects from a specified database.
Open a specified Microsoft Dynamics NAV object for design in the development environment.
Export Microsoft Dynamics NAV objects from a specified database.
Import Microsoft Dynamics NAV objects from a file to a specified database.
Create language captions on Microsoft Dynamics NAV objects in a specified database.
Export a Microsoft Dynamics NAV language module from a specified database.
Import a Microsoft Dynamics NAV language module to a specified database.
Export text strings from a specified database to a file.
Import text strings from a file to a specified database.
|To compile objects, design objects, or import and export objects as .txt files, you must have a developer license. For all other tasks, you can have either an end-user license or a developer license.|