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
 

Start-AzureSqlDatabaseExport

Start-AzureSqlDatabaseExport

microsoft.windowsazure.commands.sqldatabase.dll

Synopsis

Initiates an export operation from an Azure SQL Database to Azure Blob storage.

Syntax

Start-AzureSqlDatabaseExport [-SqlConnectionContext] [-StorageContainer] [-DatabaseName] [-BlobName] [<CommonParameters>]

Start-AzureSqlDatabaseExport [-SqlConnectionContext] [-StorageContext] [-StorageContainerName] [-DatabaseName] [-BlobName] [<CommonParameters>]

Detailed Description

Use the Start-AzureSqlDatabaseExport cmdlet to initiate an export operation from an Azure SQL Database to Blob storage. The operation requires a database server connection context. Use the Get-AzureSqlDatabaseImportExportStatus cmdlet to get status on the export operation.

Parameters

-SqlConnectionContext <ServerDataServiceSqlAuth>

The connection context to a SQL Database Server containing the SQL Database.

Aliases

None

Required?

true

Position

0

Default value

None

Accept pipeline input?

false

Accept wildcard characters?

false

-StorageContainer <AzureStorageContainer>

The Blob storage container object into which the data is exported.

Aliases

None

Required?

true

Position

1

Default value

None

Accept pipeline input?

false

Accept wildcard characters?

false

-DatabaseName <String>

The name of the database from which the data is exported.

Aliases

None

Required?

true

Position

2

Default value

None

Accept pipeline input?

false

Accept wildcard characters?

false

-BlobName <String>

The name of the Blob storage into which to export the database.

Aliases

None

Required?

true

Position

3

Default value

None

Accept pipeline input?

false

Accept wildcard characters?

false

-StorageContext <AzureStorageContext>

The context of the Blob storage.

Aliases

None

Required?

true

Position

1

Default value

None

Accept pipeline input?

false

Accept wildcard characters?

false

-StorageContainerName <String>

The name of the storage container containing the Blob into which the data is exported.

Aliases

None

Required?

true

Position

2

Default value

None

Accept pipeline input?

false

Accept wildcard characters?

false

Input Type


Return Type

Microsoft.WindowsAzure.Commands.SqlDatabase.Services.ImportExportRequest

Notes

Examples

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

This example initiates an export process from the SQL Database, "$DatabaseName", to the Blob storage, "$BlobName".

PS C:\> C:\PS>$credential = Get-Credential
C:\PS>$SqlCtx = New-AzureSqlDatabaseServerContext -ServerName $ServerName -Credentials $credential
C:\PS>$StorageCtx = New-AzureStorageContext -StorageAccountName $StorageName -StorageAccountKey $StorageKey
C:\PS>$Container = Get-AzureStorageContainer -Name $ContainerName -Context $StorageCtx
C:\PS>$exportRequest = Start-AzureSqlDatabaseExport -SqlConnectionContext $SqlCtx -StorageContainer $Container -DatabaseName $DatabaseName -BlobName $BlobName

Get-AzureSqlDatabaseImportExportStatus
Start-AzureSqlDatabaseImport