New-AzureSqlDatabase
[This topic is pre-release documentation and is subject to change in future releases. Blank topics are included as placeholders.]
New-AzureSqlDatabase
Creates a new SQL database.
Syntax
Parameter Set: Default
New-AzureSqlDatabase [-Context] <IServerDataServiceContext> [-DatabaseName] <String> [-Collation <String> ] [-Edition <DatabaseEdition> ] [-Force] [-MaxSizeGB <Int32> ] [-Confirm] [-WhatIf] [ <CommonParameters>]
Detailed Description
The New-AzureSqlDatabase cmdlet creates a new SQL Server database for the specified the SQL Server connection context.
Parameters
-Collation<String>
Collation for the newly created SQL database.
Aliases |
none |
Required? |
false |
Position? |
named |
Default Value |
none |
Accept Pipeline Input? |
false |
Accept Wildcard Characters? |
false |
-Context<IServerDataServiceContext>
The connection context to the specified Windows Azure SQL Database Server.
Aliases |
none |
Required? |
true |
Position? |
1 |
Default Value |
none |
Accept Pipeline Input? |
True (ByValue) |
Accept Wildcard Characters? |
false |
-DatabaseName<String>
The name of the new database.
Aliases |
none |
Required? |
true |
Position? |
2 |
Default Value |
none |
Accept Pipeline Input? |
false |
Accept Wildcard Characters? |
false |
-Edition<DatabaseEdition>
The edition for the SQL database. Acceptable values are Web and Business. The default value is Web.
Aliases |
none |
Required? |
false |
Position? |
named |
Default Value |
none |
Accept Pipeline Input? |
false |
Accept Wildcard Characters? |
false |
-Force
Allows the action to complete without prompting the user for confirmation.
Aliases |
none |
Required? |
false |
Position? |
named |
Default Value |
none |
Accept Pipeline Input? |
false |
Accept Wildcard Characters? |
false |
-MaxSizeGB<Int32>
The maximum size for the database 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 |
-Confirm
Prompts you for confirmation before executing the command.
Required? |
false |
Position? |
named |
Default Value |
|
Accept Pipeline Input? |
false |
Accept Wildcard Characters? |
false |
-WhatIf
Describes what would happen if you executed the command without actually executing the command.
Required? |
false |
Position? |
named |
Default Value |
|
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.SqlServer.Management.Client.DataServices.Server.Database
Notes
- To delete a database that was created by New-AzureSqlDatabase, use the Remove-AzureSqlDatabase cmdlet.
Examples
-------------------------- EXAMPLE 1 --------------------------
This example creates a new database with the name, "Database1", on the Windows Azure SQL Database Server specified by the connection $ctx.
C:\PS>$database1 = New-AzureSqlDatabase $ctx -DatabaseName "Database1" –Edition "Business" -MaxSizeGB 50 -Collation "SQL_Latin1_General_CP1_CI_AS"