Invoke-NAVApplicationDatabaseConversion

Performs a technical upgrade of a database from a previous version of Business Central.

Syntax

Invoke-NAVApplicationDatabaseConversion
      [-DatabaseServer <String>]
      -DatabaseName <String>
      [-ApplicationDatabaseCredentials <PSCredential>]
      [-Force]
      [-WhatIf]
      [-Confirm]
      [<CommonParameters>]

Description

This cmdlet converts a database from a previous Business Central platform version to the current version that you are running. The conversion updates the system tables of the database to the new schema (data structure) and provides the latest platform features and performance enhancements.

Examples

EXAMPLE 1

Invoke-NAVApplicationDatabaseConversion -DatabaseName MyApp

Performs a technical upgrade on a database named MyApp.

EXAMPLE 2

Invoke-NAVApplicationDatabaseConversion -DatabaseName MyApp -DatabaseServer "TestComputer01\NAVDEMO"

Performs a technical upgrade on a database named MyApp that is on an SQL server named TestComputer01\NAVDEMO.

Parameters

-ApplicationDatabaseCredentials

Specifies a username and password of a login account that has access to the database. If you omit this parameter, then the cmdlet uses the credentials of the current Windows user to authenticate to the database. The login account must be a member of the db_owner role on the database

Type:PSCredential
Position:Named
Default value:None
Accept pipeline input:True (ByPropertyName)
Accept wildcard characters:False
-Confirm

Prompts you for confirmation before running the cmdlet.

Type:SwitchParameter
Aliases:cf
Position:Named
Default value:None
Accept pipeline input:False
Accept wildcard characters:False
-DatabaseName

Specifies the name of the database that you want to convert.

Type:String
Position:Named
Default value:None
Accept pipeline input:True (ByPropertyName)
Accept wildcard characters:False
-DatabaseServer

Specifies the name of the computer and SQL Server instance that hosts the database that you want to convert. The value has the format ComputerName\SQLServerInstance.

Type:String
Position:Named
Default value:Localhost
Accept pipeline input:True (ByPropertyName)
Accept wildcard characters:False
-Force

You can use this parameter to convert the application database in a multitenant deployment server instance Forces the command to run without asking for user confirmation.

Type:SwitchParameter
Position:Named
Default value:False
Accept pipeline input:False
Accept wildcard characters:False
-WhatIf

Shows what would happen if the cmdlet runs. The cmdlet is not run.

Type:SwitchParameter
Aliases:wi
Position:Named
Default value:None
Accept pipeline input:False
Accept wildcard characters:False

Inputs

System.String

By property name: DatabaseServer

System.String

By property name: DatabaseName

System.Management.Automation.PSCredential

By property name: ApplicationDatabaseCredentials