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:
Command | Task |
---|---|
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. |
Note |
---|
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. |