내보내기(0) 인쇄
모두 확장
EN
이 콘텐츠는 한국어로 제공되지 않아 영어 버전으로 표시됩니다.

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

Microsoft는 MSDN 웹 사이트에 대한 귀하의 의견을 이해하기 위해 온라인 설문 조사를 진행하고 있습니다. 참여하도록 선택하시면 MSDN 웹 사이트에서 나가실 때 온라인 설문 조사가 표시됩니다.

참여하시겠습니까?
표시:
© 2014 Microsoft