Creates a new database for Microsoft Dynamics NAV on an SQL server.
finsql.exe command=createdatabase, [servername=<server>,] [database=<database>,] [collationname=<collation>,] [logfile=<path and filename>,] [username=<user name>,] [password=<password>,] [ntauthentication=<yes|no|0|1>]
The name of the database server on which you want to run the command and create the database.
To view the name of the server on which the current database is stored, on the File menu, choose Database, and then choose Information. Use the value of the Database Server field for the servername parameter.
The name of the new database that you want to create.
To view the name of the current database, on the File menu, choose Database, and then choose Information. Use the value of the Database Name field for the database parameter.
The collation to use when you create a new database. The value must be one of the following:
A full language culture name. For example, da-DK for Danish or hu-HU for Hungarian. ·
A SQL Server collation name without case or accent. For example, Latin1_General_100. ·
A SQL Server collation name with case and accent. For example, Danish_Greenlandic_100_CS_AI.
The path and file name for the file that contains error messages that result from the command. If there are no errors, then a log file is not created.
By default, the file is named naverrorlog.txt and is located in the same location as finsql.exe.
The navcommandresult.txt file, which contains information about the success or failure of the command, is created in the folder that is specified by the logfile parameter.
When you run finsql.exe with a command, the previous log file and result file are deleted.
If User Access Control (UAC) is turned on and you do not specify to run the Command Prompt window as Administrator, then the Command Prompt window runs as a standard user. In this case, if you do not specify the logfile parameter, then the command fails because the standard user cannot write to the default location of the log file.
The user name to use to authenticate to the database. The user name must exist in the database. If you do not specify a user name and password, then the command uses the Windows user name and password of the current user to authenticate to the database.
If User Access Control (UAC) is turned on and you do not specify to run the Command Prompt window as Administrator, then the Command Prompt window runs as a standard user. In this case, if you do not specify the username parameter and the current Windows user is an Administrator, then the command is run as the standard user.
If you specify the username parameter, then you must also specify the password parameter and the ntauthentication parameter must be no.
For more information about database users and permissions, see Setting Database Owner and Security Administration Permissions.
The password to use with the username parameter to authenticate to the database. If you do not specify a user name and password, then the command uses the Windows user name and password of the current user to authenticate to the database.
Specifies if you want to use NT authentication. The possible values are yes, no, 1, or 0. If you specify the username and password parameters, then you must specify ntauthentication=no or ntauthentication=0.
You use the CreateDatabase command together with the finsql.exe executable. Finsql.exe is the executable file that runs the development environment. By default, finsql.exe is located at C:\Program Files (x86)\Microsoft Dynamics NAV\70\RoleTailored Client\.
This example creates a database on a SQL server that is named TestComputer01\NAVDEMO. The new database is given the name NAV Danish Database and uses the collation da-DK.
finsql.exe command=createdatabase, servername=TestComputer01\NAVDEMO, database="NAV Danish Database", collationname=da-dk