Eksportuj (0) Drukuj
Rozwiń wszystko
EN
Ta zawartość nie jest dostępna w wymaganym języku. Wersja w języku angielskim znajduje się tutaj.

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

Related topics

Pokaż:
© 2014 Microsoft