Start-AzureSqlDatabaseImport
[This topic is pre-release documentation and is subject to change in future releases. Blank topics are included as placeholders.]
Start-AzureSqlDatabaseImport
Initiates an import operation from Windows Azure blob storage to an Azure SQL Database.
Syntax
Parameter Set: ByContainerName
Start-AzureSqlDatabaseImport [-SqlConnectionContext] <ServerDataServiceSqlAuth> [-StorageContext] <AzureStorageContext> [-StorageContainerName] <String> [-DatabaseName] <String> [-BlobName] <String> [-DatabaseMaxSize <Int32> ] [-Edition <DatabaseEdition> ] [ <CommonParameters>]
Parameter Set: ByContainerObject
Start-AzureSqlDatabaseImport [-SqlConnectionContext] <ServerDataServiceSqlAuth> [-StorageContainer] <AzureStorageContainer> [-DatabaseName] <String> [-BlobName] <String> [-DatabaseMaxSize <Int32> ] [-Edition <DatabaseEdition> ] [ <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
-BlobName<String>
The name of the blob storage from which to import the database.
Aliases |
none |
Required? |
true |
Position? |
5 |
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.
Web Edition values: 1 or 5
Business Edition values: 10, 20, 30, 40, 50, 100, or 150
Aliases |
none |
Required? |
false |
Position? |
named |
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? |
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 |
-SqlConnectionContext<ServerDataServiceSqlAuth>
The connection context to a SQL Database Server containing the SQL Database.
Aliases |
none |
Required? |
true |
Position? |
1 |
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? |
2 |
Default Value |
none |
Accept Pipeline Input? |
false |
Accept Wildcard Characters? |
false |
-StorageContainerName<String>
The name of the blob storage.
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? |
2 |
Default Value |
none |
Accept Pipeline Input? |
false |
Accept Wildcard Characters? |
false |
<CommonParameters>
This cmdlet supports the common parameters: -Verbose, -Debug, -ErrorAction, -ErrorVariable, -OutBuffer, and -OutVariable. For more information, see about_CommonParameters
Inputs
The input type is the type of the objects that you can pipe to the cmdlet.
Outputs
The output type is the type of the objects that the cmdlet emits.
- Microsoft.WindowsAzure.Management.SqlDatabase.Services.ImportExportRequest
Examples
-------------------------- EXAMPLE 1 --------------------------
This example initiates an import process from the blob storage, "$BlobName", into the SQL Database, "DatabaseName".
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