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]
      [-ProgressAction <ActionPreference>]
      [-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.

By default, you'll have to uninstall all extensions before you can run this cmdlet. You can use the -Force parameter to run the cmdlet without uninstalling extensions, but this is only recommended for multitenant deployments.

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
Required:False
Accept pipeline input:True
Accept wildcard characters:False

-Confirm

Prompts you for confirmation before running the cmdlet.

Type:SwitchParameter
Aliases:cf
Position:Named
Default value:None
Required:False
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
Required:True
Accept pipeline input:True
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
Required:False
Accept pipeline input:True
Accept wildcard characters:False

-Force

This parameter let's you run the cmdlet even if there are installed extensions. 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
Required:False
Accept pipeline input:False
Accept wildcard characters:False

-ProgressAction

A common PowerShell parameter that determines how PowerShell responds to progress updates generated by a script, cmdlet, or provider. Learn more.

Type:ActionPreference
Aliases:proga
Position:Named
Default value:None
Required: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
Required:False
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