Development Environment Commands
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\100\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 Dynamics NAV database. |
| UpgradeDatabase | Upgrades the specified Dynamics NAV database on the specified server. |
| CompileObjects | Compile Dynamics NAV objects from a specified database. |
| DeleteObjects | Delete Dynamics NAV objects from a specified database. |
| DesignObject | Open a specified Dynamics NAV object for design in the development environment. |
| ExportObjects | Export Dynamics NAV objects from a specified database. |
| ImportObjects | Import Dynamics NAV objects from a file to a specified database. |
| CreateLanguage | Create language captions on Dynamics NAV objects in a specified database. |
| ExportLangModule | Export a Dynamics NAV language module from a specified database. |
| ImportLangModule | Import a 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. |
| GetBuildVersion | Gets the Dynamics NAV product name and build version. |
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.