< Back
Get-AzureRmSqlDatabaseImportExportStatus
Post
NAME Get-AzureRmSqlDatabaseImportExportStatus
SYNOPSIS
Gets the details of an import or export of an Azure SQL Database.
SYNTAX
Get-AzureRmSqlDatabaseImportExportStatus [-OperationStatusLink] <String> [-DefaultProfile <IAzureContextContainer>] [-Confirm] [-WhatIf]
[<CommonParameters>]
DESCRIPTION
The Get-AzureRmSqlDatabaseImportExportStatus cmdlet gets details of a bacpac file import from a storage account to an Azure SQL Database or an
export of an Azure SQL Database as a bacpac file to a storage account.
This cmdlet is also supported by the SQL Server Stretch Database service on Azure.
PARAMETERS
-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
-OperationStatusLink <String>
Specifies the status link that is returned from the New-AzureRmSqlDatabaseExport or New-AzureRmSqlDatabaseImport cmdlets.
Required? true
Position? 0
Default value None
Accept pipeline input? True (ByPropertyName)
Accept wildcard characters? false
-Confirm [<SwitchParameter>]
Prompts you for confirmation before running the cmdlet.
Required? false
Position? named
Default value False
Accept pipeline input? False
Accept wildcard characters? false
-WhatIf [<SwitchParameter>]
Shows what would happen if the cmdlet runs. The cmdlet is not run.
Required? false
Position? named
Default value False
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
NOTES
* Keywords: azure, azurerm, arm, resource, management, manager, sql, database, mssql
Example 1: Get the import and export status of a SQL database
PS C:\\>Get-AzureRmSqlDatabaseImportExportStatus -OperationStatusLink "https://management.contoso.com/subscrip ... 0-00000000
0000/resourceGroups/resource01/providers/Microsoft.Sql/servers/server01/databases/database01/importExportOperationResults/00000000-000-0000-0000-00
0000000000?api-version=2014-04-01"
OperationStatusLink :
ErrorMessage :
LastModifiedTime : 4/15/2016 10:16:14 PM
QueuedTime : 4/15/2016 10:16:13 PM
StatusMessage : Running, Progress = 5.00 %
Status : InProgress
This command gets the status of an import or export request for a database at the specified URL.
RELATED LINKS
Online Version: https://docs.microsoft.com/en-us/powers ... portstatus
New-AzureRmSqlDatabaseExport
New-AzureRmSqlDatabaseImport
SQL Database Documentation https://docs.microsoft.com/azure/sql-database/
SYNOPSIS
Gets the details of an import or export of an Azure SQL Database.
SYNTAX
Get-AzureRmSqlDatabaseImportExportStatus [-OperationStatusLink] <String> [-DefaultProfile <IAzureContextContainer>] [-Confirm] [-WhatIf]
[<CommonParameters>]
DESCRIPTION
The Get-AzureRmSqlDatabaseImportExportStatus cmdlet gets details of a bacpac file import from a storage account to an Azure SQL Database or an
export of an Azure SQL Database as a bacpac file to a storage account.
This cmdlet is also supported by the SQL Server Stretch Database service on Azure.
PARAMETERS
-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
-OperationStatusLink <String>
Specifies the status link that is returned from the New-AzureRmSqlDatabaseExport or New-AzureRmSqlDatabaseImport cmdlets.
Required? true
Position? 0
Default value None
Accept pipeline input? True (ByPropertyName)
Accept wildcard characters? false
-Confirm [<SwitchParameter>]
Prompts you for confirmation before running the cmdlet.
Required? false
Position? named
Default value False
Accept pipeline input? False
Accept wildcard characters? false
-WhatIf [<SwitchParameter>]
Shows what would happen if the cmdlet runs. The cmdlet is not run.
Required? false
Position? named
Default value False
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
NOTES
* Keywords: azure, azurerm, arm, resource, management, manager, sql, database, mssql
Example 1: Get the import and export status of a SQL database
PS C:\\>Get-AzureRmSqlDatabaseImportExportStatus -OperationStatusLink "https://management.contoso.com/subscrip ... 0-00000000
0000/resourceGroups/resource01/providers/Microsoft.Sql/servers/server01/databases/database01/importExportOperationResults/00000000-000-0000-0000-00
0000000000?api-version=2014-04-01"
OperationStatusLink :
ErrorMessage :
LastModifiedTime : 4/15/2016 10:16:14 PM
QueuedTime : 4/15/2016 10:16:13 PM
StatusMessage : Running, Progress = 5.00 %
Status : InProgress
This command gets the status of an import or export request for a database at the specified URL.
RELATED LINKS
Online Version: https://docs.microsoft.com/en-us/powers ... portstatus
New-AzureRmSqlDatabaseExport
New-AzureRmSqlDatabaseImport
SQL Database Documentation https://docs.microsoft.com/azure/sql-database/