Get-AzureSqlDatabaseImportExportStatus

Gets the status of an import or export request.

Note

The cmdlets referenced in this documentation are for managing legacy Azure resources that use Azure Service Manager (ASM) APIs. This legacy PowerShell module isn't recommended when creating new resources since ASM is scheduled for retirement. For more information, see Azure Service Manager retirement.

The Az PowerShell module is the recommended PowerShell module for managing Azure Resource Manager (ARM) resources with PowerShell.

Syntax

Get-AzureSqlDatabaseImportExportStatus
   -Username <String>
   -Password <String>
   -ServerName <String>
   -RequestId <String>
   [-Profile <AzureSMProfile>]
   [<CommonParameters>]
Get-AzureSqlDatabaseImportExportStatus
   -Request <ImportExportRequest>
   [-Profile <AzureSMProfile>]
   [<CommonParameters>]

Description

The Get-AzureSqlDatabaseImportExportStatus cmdlet gets the status of an import or export request. The Start-AzureSqlDatabaseImport or Start-AzureSqlDatabaseExport cmdlet initiates requests. You can specify the request object by using the Request parameter, or you can identify the request by using the RequestId parameter and the Username, Password, and ServerName parameters.

Examples

Example 1: Get the status of an export request

PS C:\> $ExportRequest = Start-AzureSqlDatabaseExport -SqlConnectionContext $SqlContext -StorageContainer $Container -DatabaseName $DatabaseName -BlobName $BlobName
PS C:\> Get-AzureSqlDatabaseImportExportStatus -Request $ExportRequest

The first command creates an export request, and then stores it in the $ExportRequest variable.

The second command gets the status of the export request stored in $ExportRequest.

Parameters

-Password

Specifies the password that is required to connect to the Azure SQL Database server. You must specify this parameter if you specified the RequestId parameter.

Type:String
Position:Named
Default value:None
Required:True
Accept pipeline input:False
Accept wildcard characters:False

-Profile

Specifies the Azure profile from which this cmdlet reads. If you do not specify a profile, this cmdlet reads from the local default profile.

Type:AzureSMProfile
Position:Named
Default value:None
Required:False
Accept pipeline input:False
Accept wildcard characters:False

-Request

Specifies an ImportExportRequest object. To obtain an import or export request object, use the Start-AzureSqlDatabaseImport or Start-AzureSqlDatabaseExport cmdlet.

Type:ImportExportRequest
Position:Named
Default value:None
Required:True
Accept pipeline input:False
Accept wildcard characters:False

-RequestId

Specifies the GUID of the import or export operation for which this cmdlet gets status. If you specify this parameter, you must specify the UserName, Password, and ServerName parameters.

Type:String
Position:Named
Default value:None
Required:True
Accept pipeline input:False
Accept wildcard characters:False

-ServerName

Specifies the name of the Azure SQL Database server. You must specify this parameter if you specified the RequestId parameter.

Type:String
Position:Named
Default value:None
Required:True
Accept pipeline input:False
Accept wildcard characters:False

-Username

Specifies the user name required to connect to the Azure SQL Database server. You must specify this parameter if you specified the RequestId parameter.

Type:String
Position:Named
Default value:None
Required:True
Accept pipeline input:False
Accept wildcard characters:False

Outputs

Microsoft.WindowsAzure.Commands.SqlDatabase.Services.ImportExport.StatusInfo