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

BuildVirtualMetadata

Regenerates C# and metadata information for virtual tables in a specified database.

CreateDatabase

Create a new Microsoft Dynamics NAV database.

UpgradeDatabase

Upgrades the specified Microsoft Dynamics NAV database on the specified server.

CompileObjects

Compile Microsoft Dynamics NAV objects from a specified database.

DeleteObjects

Delete Microsoft Dynamics NAV objects from a specified database.

DesignObject

Open a specified Microsoft Dynamics NAV object for design in the development environment.

ExportObjects

Export Microsoft Dynamics NAV objects from a specified database.

ImportObjects

Import Microsoft Dynamics NAV objects from a file to a specified database.

CreateLanguage

Create language captions on Microsoft Dynamics NAV objects in a specified database.

ExportLangModule

Export a Microsoft Dynamics NAV language module from a specified database.

ImportLangModule

Import a Microsoft Dynamics NAV language module to a specified database.

ExportTranslate

Export text strings from a specified database to a file.

ImportTranslate

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.

See Also