< Back
Start-AzureRmSqlServerUpgrade
Post
NAME Start-AzureRmSqlServerUpgrade
SYNOPSIS
Starts the upgrade of a SQL Database server.
SYNTAX
Start-AzureRmSqlServerUpgrade [-ResourceGroupName] <String> [-DatabaseCollection <RecommendedDatabaseProperties[]>] [-DefaultProfile
<IAzureContextContainer>] [-ElasticPoolCollection <UpgradeRecommendedElasticPoolProperties[]>] [-ScheduleUpgradeAfterUtcDateTime <DateTime>]
-ServerName <String> -ServerVersion <String> [<CommonParameters>]
DESCRIPTION
The Start-AzureRmSqlServerUpgrade cmdlet starts the upgrade of an Azure SQL Database server version 11 to version 12. You can monitor the progress
of an upgrade by using the Get-AzureRmSqlServerUpgrade cmdlet.
PARAMETERS
-DatabaseCollection <RecommendedDatabaseProperties[]>
Specifies an array of RecommendedDatabaseProperties objects that this cmdlet uses for the server upgrade.
Required? false
Position? named
Default value None
Accept pipeline input? False
Accept wildcard characters? false
-DefaultProfile <IAzureContextContainer>
The credentials, account, tenant, and subscription used for communication with azure
Required? false
Position? named
Default value None
Accept pipeline input? False
Accept wildcard characters? false
-ElasticPoolCollection <UpgradeRecommendedElasticPoolProperties[]>
Specifies an array of UpgradeRecommendedElasticPoolProperties objects to use for the server upgrade.
Required? false
Position? named
Default value None
Accept pipeline input? False
Accept wildcard characters? false
-ResourceGroupName <String>
Specifies the name of the resource group to which the server is assigned.
Required? true
Position? 0
Default value None
Accept pipeline input? True (ByPropertyName)
Accept wildcard characters? false
-ScheduleUpgradeAfterUtcDateTime <DateTime>
Specifies the earliest time, as a DateTime object, to upgrade the server. Specify a value in the ISO8601 format, in Coordinated Universal Time
(UTC). For more information, type `Get-Help Get-Date`.
Required? false
Position? named
Default value None
Accept pipeline input? False
Accept wildcard characters? false
-ServerName <String>
Specifies the name of the server that this cmdlet upgrades.
Required? true
Position? named
Default value None
Accept pipeline input? True (ByPropertyName)
Accept wildcard characters? false
-ServerVersion <String>
Specifies the version to which this cmdlet upgrades the server. The only valid value is 12.0.
Required? true
Position? named
Default value None
Accept pipeline input? False
Accept wildcard characters? false
<CommonParameters>
This cmdlet supports the common parameters: Verbose, Debug,
ErrorAction, ErrorVariable, WarningAction, WarningVariable,
OutBuffer, PipelineVariable, and OutVariable. For more information, see
about_CommonParameters (http://go.microsoft.com/fwlink/?LinkID=113216).
INPUTS
None
This cmdlet does not accept any input.
OUTPUTS
Microsoft.Azure.Commands.Sql.ServerUpgrade.Model.AzureSqlServerUpgradeModel
NOTES
Example 1: Upgrade a server
PS C:\\>Start-AzureRmSqlServerUpgrade -ResourceGroupName "ResourceGroup01" -ServerName "Server01" -ServerVersion 12.0
ResourceGroupName : ResourceGroup01
ServerName : Server01
ServerVersion : 12.0
ScheduleUpgradeAfterUtcDateTime :
DatabaseCollection :
This command upgrades the server named server01 assigned to resource group TesourceGroup01.
Example 2: Upgrade a server by using schedule time and database recommendation
PS C:\\>$ScheduleTime = (Get-Date).AddMinutes(5).ToUniversalTime()
PS C:\\> $DatabaseMap = New-Object -TypeName Microsoft.Azure.Management.Sql.Models.RecommendedDatabaseProperties
PS C:\\> $DatabaseMap.Name = "contosodb"
PS C:\\> $DatabaseMap.TargetEdition = "Standard"
PS C:\\> $DatabaseMap.TargetServiceLevelObjective = "S0"
PS C:\\> Start-AzureRmSqlServerUpgrade -ResourceGroupName "ResourceGroup01" -ServerName "Server01" -ServerVersion 12.0
-ScheduleUpgradeAfterUtcDateTime $ScheduleTime -DatabaseCollection ($DatabaseMap)
The first command creates a time five minutes in the future by using the Get-Date cmdlet. The command stores the date in the variable
$ScheduleTime. For more information, type `Get-Help Get-Date`.
The second command creates a RecommendedDatabaseProperties object, and then stores that object in the variable $DatabaseMap.
The next three commands assign values to properties of the object stored in $DatabaseMap.
The final command upgrades the existing server named Server01 to version 12.0. The earliest time to upgrade is five minutes after you run the
command, as specified by the $ScheduleTime variable. After the upgrade, the database contosodb will be running the Standard edition and have the
Service Level Objective S0.
RELATED LINKS
Online Version: https://docs.microsoft.com/en-us/powers ... verupgrade
Get-AzureRmSqlServerUpgrade
Stop-AzureRmSqlServerUpgrade
SQL Database Documentation https://docs.microsoft.com/azure/sql-database/
SYNOPSIS
Starts the upgrade of a SQL Database server.
SYNTAX
Start-AzureRmSqlServerUpgrade [-ResourceGroupName] <String> [-DatabaseCollection <RecommendedDatabaseProperties[]>] [-DefaultProfile
<IAzureContextContainer>] [-ElasticPoolCollection <UpgradeRecommendedElasticPoolProperties[]>] [-ScheduleUpgradeAfterUtcDateTime <DateTime>]
-ServerName <String> -ServerVersion <String> [<CommonParameters>]
DESCRIPTION
The Start-AzureRmSqlServerUpgrade cmdlet starts the upgrade of an Azure SQL Database server version 11 to version 12. You can monitor the progress
of an upgrade by using the Get-AzureRmSqlServerUpgrade cmdlet.
PARAMETERS
-DatabaseCollection <RecommendedDatabaseProperties[]>
Specifies an array of RecommendedDatabaseProperties objects that this cmdlet uses for the server upgrade.
Required? false
Position? named
Default value None
Accept pipeline input? False
Accept wildcard characters? false
-DefaultProfile <IAzureContextContainer>
The credentials, account, tenant, and subscription used for communication with azure
Required? false
Position? named
Default value None
Accept pipeline input? False
Accept wildcard characters? false
-ElasticPoolCollection <UpgradeRecommendedElasticPoolProperties[]>
Specifies an array of UpgradeRecommendedElasticPoolProperties objects to use for the server upgrade.
Required? false
Position? named
Default value None
Accept pipeline input? False
Accept wildcard characters? false
-ResourceGroupName <String>
Specifies the name of the resource group to which the server is assigned.
Required? true
Position? 0
Default value None
Accept pipeline input? True (ByPropertyName)
Accept wildcard characters? false
-ScheduleUpgradeAfterUtcDateTime <DateTime>
Specifies the earliest time, as a DateTime object, to upgrade the server. Specify a value in the ISO8601 format, in Coordinated Universal Time
(UTC). For more information, type `Get-Help Get-Date`.
Required? false
Position? named
Default value None
Accept pipeline input? False
Accept wildcard characters? false
-ServerName <String>
Specifies the name of the server that this cmdlet upgrades.
Required? true
Position? named
Default value None
Accept pipeline input? True (ByPropertyName)
Accept wildcard characters? false
-ServerVersion <String>
Specifies the version to which this cmdlet upgrades the server. The only valid value is 12.0.
Required? true
Position? named
Default value None
Accept pipeline input? False
Accept wildcard characters? false
<CommonParameters>
This cmdlet supports the common parameters: Verbose, Debug,
ErrorAction, ErrorVariable, WarningAction, WarningVariable,
OutBuffer, PipelineVariable, and OutVariable. For more information, see
about_CommonParameters (http://go.microsoft.com/fwlink/?LinkID=113216).
INPUTS
None
This cmdlet does not accept any input.
OUTPUTS
Microsoft.Azure.Commands.Sql.ServerUpgrade.Model.AzureSqlServerUpgradeModel
NOTES
Example 1: Upgrade a server
PS C:\\>Start-AzureRmSqlServerUpgrade -ResourceGroupName "ResourceGroup01" -ServerName "Server01" -ServerVersion 12.0
ResourceGroupName : ResourceGroup01
ServerName : Server01
ServerVersion : 12.0
ScheduleUpgradeAfterUtcDateTime :
DatabaseCollection :
This command upgrades the server named server01 assigned to resource group TesourceGroup01.
Example 2: Upgrade a server by using schedule time and database recommendation
PS C:\\>$ScheduleTime = (Get-Date).AddMinutes(5).ToUniversalTime()
PS C:\\> $DatabaseMap = New-Object -TypeName Microsoft.Azure.Management.Sql.Models.RecommendedDatabaseProperties
PS C:\\> $DatabaseMap.Name = "contosodb"
PS C:\\> $DatabaseMap.TargetEdition = "Standard"
PS C:\\> $DatabaseMap.TargetServiceLevelObjective = "S0"
PS C:\\> Start-AzureRmSqlServerUpgrade -ResourceGroupName "ResourceGroup01" -ServerName "Server01" -ServerVersion 12.0
-ScheduleUpgradeAfterUtcDateTime $ScheduleTime -DatabaseCollection ($DatabaseMap)
The first command creates a time five minutes in the future by using the Get-Date cmdlet. The command stores the date in the variable
$ScheduleTime. For more information, type `Get-Help Get-Date`.
The second command creates a RecommendedDatabaseProperties object, and then stores that object in the variable $DatabaseMap.
The next three commands assign values to properties of the object stored in $DatabaseMap.
The final command upgrades the existing server named Server01 to version 12.0. The earliest time to upgrade is five minutes after you run the
command, as specified by the $ScheduleTime variable. After the upgrade, the database contosodb will be running the Standard edition and have the
Service Level Objective S0.
RELATED LINKS
Online Version: https://docs.microsoft.com/en-us/powers ... verupgrade
Get-AzureRmSqlServerUpgrade
Stop-AzureRmSqlServerUpgrade
SQL Database Documentation https://docs.microsoft.com/azure/sql-database/