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
ByConnectionInfo
Get-AzureSqlDatabaseImportExportStatus
-Username <String>
-Password <String>
-ServerName <String>
-RequestId <String>
[-Profile <AzureSMProfile>]
[<CommonParameters>]
ByRequestObject
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.
Parameter properties
| Type: | String |
| Default value: | None |
| Supports wildcards: | False |
| DontShow: | False |
Parameter sets
ByConnectionInfo
| Position: | Named |
| Mandatory: | True |
| Value from pipeline: | False |
| Value from pipeline by property name: | False |
| Value from remaining arguments: | 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.
Parameter properties
| Type: | AzureSMProfile |
| Default value: | None |
| Supports wildcards: | False |
| DontShow: | False |
Parameter sets
(All)
| Position: | Named |
| Mandatory: | False |
| Value from pipeline: | False |
| Value from pipeline by property name: | False |
| Value from remaining arguments: | False |
-Request
Specifies an ImportExportRequest object. To obtain an import or export request object, use the Start-AzureSqlDatabaseImport or Start-AzureSqlDatabaseExport cmdlet.
Parameter properties
| Type: | ImportExportRequest |
| Default value: | None |
| Supports wildcards: | False |
| DontShow: | False |
Parameter sets
ByRequestObject
| Position: | Named |
| Mandatory: | True |
| Value from pipeline: | False |
| Value from pipeline by property name: | False |
| Value from remaining arguments: | 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.
Parameter properties
| Type: | String |
| Default value: | None |
| Supports wildcards: | False |
| DontShow: | False |
Parameter sets
ByConnectionInfo
| Position: | Named |
| Mandatory: | True |
| Value from pipeline: | False |
| Value from pipeline by property name: | False |
| Value from remaining arguments: | False |
-ServerName
Specifies the name of the Azure SQL Database server. You must specify this parameter if you specified the RequestId parameter.
Parameter properties
| Type: | String |
| Default value: | None |
| Supports wildcards: | False |
| DontShow: | False |
Parameter sets
ByConnectionInfo
| Position: | Named |
| Mandatory: | True |
| Value from pipeline: | False |
| Value from pipeline by property name: | False |
| Value from remaining arguments: | 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.
Parameter properties
| Type: | String |
| Default value: | None |
| Supports wildcards: | False |
| DontShow: | False |
Parameter sets
ByConnectionInfo
| Position: | Named |
| Mandatory: | True |
| Value from pipeline: | False |
| Value from pipeline by property name: | False |
| Value from remaining arguments: | False |
CommonParameters
This cmdlet supports the common parameters: -Debug, -ErrorAction, -ErrorVariable, -InformationAction, -InformationVariable, -OutBuffer, -OutVariable, -PipelineVariable, -ProgressAction, -Verbose, -WarningAction, and -WarningVariable. For more information, see about_CommonParameters.