Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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.