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-AzureSqlDatabaseImport

Start-AzureSqlDatabaseImport

microsoft.windowsazure.commands.sqldatabase.dll

Synopsis

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

Syntax

Start-AzureSqlDatabaseImport [-SqlConnectionContext] [-StorageContainer] [-DatabaseName] [-BlobName] [-Edition] [-DatabaseMaxSize] [<CommonParameters>]

Start-AzureSqlDatabaseImport [-SqlConnectionContext] [-StorageContext] [-StorageContainerName] [-DatabaseName] [-BlobName] [-Edition] [-DatabaseMaxSize] [<CommonParameters>]

Detailed Description

Use the Start-AzureSqlDatabaseImport cmdlet to initiate an import operation from Blob storage to an Azure SQL Database. If the database does not exist, it is created using the size and edition values specified. The operation requires a database server connection context. Use the Get-AzureSqlDatabaseImportExportStatus cmdlet to get status on the import 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 name of the storage container containing the Blob from which to import.

Aliases

None

Required?

true

Position

1

Default value

None

Accept pipeline input?

false

Accept wildcard characters?

false

-DatabaseName <String>

The name of the database into which the data is imported. If the database does not exist, it is created with this name.

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 from which to import the database.

Aliases

None

Required?

true

Position

3

Default value

None

Accept pipeline input?

false

Accept wildcard characters?

false

-Edition <DatabaseEdition>

If the database does not exist, it is created as this edition. Acceptable values are Web and Business. The default is Web.

Aliases

None

Required?

false

Position

named

Default value

None

Accept pipeline input?

false

Accept wildcard characters?

false

-DatabaseMaxSize <Int32>

If the database does not exist, it is created with this maximum size in gigabytes. The acceptable values differ based on edition.

Aliases

None

Required?

false

Position

named

Default value

None

Accept pipeline input?

false

Accept wildcard characters?

false

-StorageContext <AzureStorageContext>

The connection context of the Blob storage container.

Aliases

None

Required?

true

Position

1

Default value

None

Accept pipeline input?

false

Accept wildcard characters?

false

-StorageContainerName <String>

The name of the Blob storage container.

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 import process from the Blob storage, "$BlobName", into the SQL Database, "DatabaseName".

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>$importRequest = Start-AzureSqlDatabaseImport -SqlConnectionContext $SqlCtx -StorageContainer $Container -DatabaseName $DatabaseName -BlobName $BlobName

Get-AzureSqlDatabaseImportExportStatus
Start-AzureSqlDatabaseExport