Cmdlets

Choose a cmdlet from the list on the left or search for a specific cmdlet. Choose a cmdlet from the list or search for a specific cmdlet.
About Help  Providers
 

Get-AzureSqlDatabaseImportExportStatus

Get-AzureSqlDatabaseImportExportStatus

microsoft.windowsazure.commands.sqldatabase.dll

Synopsis

Returns the status of an import or export operation between Azure blob storage and an Azure SQL Database.

Syntax

Get-AzureSqlDatabaseImportExportStatus [-Username] [-Password] [-ServerName] [-RequestId] [<CommonParameters>]

Get-AzureSqlDatabaseImportExportStatus [-Request] [<CommonParameters>]

Detailed Description

This cmdlet returns the status of an import or export request initiated by the Start-AzureSqlDatabaseImport or Start-AzureSqlDatabaseExport cmdlet. You can specify the request object with the Request parameter, or you can identify the request with the RequestId parameter along with the Username, Password, and ServerName parameters.

Parameters

-Username <String>

If RequestId is specified, the user name required to connect to the Azure SQL Database Server.

Aliases

None

Required?

true

Position

0

Default value

None

Accept pipeline input?

false

Accept wildcard characters?

false

-Password <String>

If RequestId is specified, the password required to connect to the Azure SQL Database Server.

Aliases

None

Required?

true

Position

1

Default value

None

Accept pipeline input?

false

Accept wildcard characters?

false

-ServerName <String>

If RequestId is specified, the name of the Azure SQL Database Server.

Aliases

None

Required?

true

Position

2

Default value

None

Accept pipeline input?

false

Accept wildcard characters?

false

-RequestId <String>

The GUID of the import or export operation for which to return status. This parameter requires the UserName, Password, and ServerName parameters.

Aliases

None

Required?

true

Position

3

Default value

None

Accept pipeline input?

false

Accept wildcard characters?

false

-Request <ImportExportRequest>

The ImportExportRequest object representing the import or export request, as returned by the Start-AzureSqlDatabaseImport or Start-AzureSqlDatabaseExport cmdlet.

Aliases

None

Required?

true

Position

0

Default value

None

Accept pipeline input?

false

Accept wildcard characters?

false

Input Type


Return Type

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

Notes

Examples

-------------------------- EXAMPLE 1 --------------------------

This example returns the status of an export request

PS C:\> C:\PS>$exportRequest = Start-AzureSqlDatabaseExport -SqlConnectionContext $SqlCtx -StorageContainer $Container -DatabaseName $DatabaseName -BlobName $blobName
C:\PS>Get-AzureSqlDatabaseImportExportStatus -Request $exportRequest

Start-AzureSqlDatabaseExport
Start-AzureSqlDatabaseImport