Share via


Create-NAVDatabase

Creates a new Business Central application database.

Syntax

All (Default)

Create-NAVDatabase
    [-DatabaseName] <String>
    [-DatabaseServer <String>]
    [-Collation <String>]
    [-LogPath <String>]
    [<CommonParameters>]

DatabaseAuthentication

Create-NAVDatabase
    [-DatabaseName] <String>
    -Username <String>
    -Password <String>
    [-DatabaseServer <String>]
    [-Collation <String>]
    [-LogPath <String>]
    [<CommonParameters>]

Description

The Create-NAVDatabase creates a new NAV database that includes the NAV system tables.

Examples

EXAMPLE 1

Create-NAVDatabase MyNewApp

Creates a new NAV database named MyNewApp.

EXAMPLE 2

Create-NAVDatabase MyNewApp -ServerName "TestComputer01\NAVDEMO" -Collation "da-dk"

Creates a new NAV database named MyNewApp on TestComputer01\NAVDEMO Sql server with Danish collation.

Parameters

-Collation

Specifies the collation of the database.

Parameter properties

Type:String
Default value:None
Supports wildcards:False
DontShow:False

Parameter sets

(All)
Position:Named
Mandatory:False
Value from pipeline:False
Value from pipeline by property name:False
Value from remaining arguments:False

-DatabaseName

Specifies the name of the Business Central database that will be created.

Parameter properties

Type:String
Default value:None
Supports wildcards:False
DontShow:False

Parameter sets

(All)
Position:1
Mandatory:True
Value from pipeline:False
Value from pipeline by property name:False
Value from remaining arguments:False

-DatabaseServer

Specifies the name of the SQL server instance on which you want to create the database. The default value is the default instance on the local host (.).

Parameter properties

Type:String
Default value:.
Supports wildcards:False
DontShow:False

Parameter sets

(All)
Position:Named
Mandatory:False
Value from pipeline:False
Value from pipeline by property name:False
Value from remaining arguments:False

-LogPath

Specifies the log folder.

Parameter properties

Type:String
Default value:"$Env:TEMP\NavIde\$([GUID]::NewGuid().GUID)"
Supports wildcards:False
DontShow:False

Parameter sets

(All)
Position:Named
Mandatory:False
Value from pipeline:False
Value from pipeline by property name:False
Value from remaining arguments:False

-Password

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 credentials of the current Windows user to authenticate to the database.

Parameter properties

Type:String
Default value:None
Supports wildcards:False
DontShow:False

Parameter sets

DatabaseAuthentication
Position:Named
Mandatory:True
Value from pipeline:False
Value from pipeline by property name:False
Value from remaining arguments:False

-Username

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 credentials of the current Windows user to authenticate to the database.

Parameter properties

Type:String
Default value:None
Supports wildcards:False
DontShow:False

Parameter sets

DatabaseAuthentication
Position:Named
Mandatory:True
Value from pipeline:False
Value from pipeline by property name:False
Value from remaining arguments:False

CommonParameters

This cmdlet supports the common parameters: -Debug, -ErrorAction, -ErrorVariable, -InformationAction, -InformationVariable, -OutBuffer, -OutVariable, -PipelineVariable, -ProgressAction, -Verbose, -WarningAction, and -WarningVariable. For more information, see about_CommonParameters.

Inputs

None

You cannot pipe input into this function.

Outputs

None