New-AzureSqlServer
New-AzureSqlServer
Creates an Azure SQL Database server.
Syntax
Parameter Set: Default
New-AzureSqlServer [-ResourceGroupName] <System.String> -Location <System.String> -ServerName <System.String> -SqlAdministratorCredentials <System.Management.Automation.PSCredential> [-Profile <Microsoft.Azure.Common.Authentication.Models.AzureProfile> ] [-ServerVersion <System.String> ] [-Tags <System.Collections.Generic.Dictionary`2[[System.String, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089],[System.String, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]]> ]
Detailed Description
The New-AzureSqlServer cmdlet creates an Azure SQL Database server.
Parameters
-Location<System.String>
Specifies the location of the data center where this cmdlet creates the server.
Aliases |
none |
Required? |
true |
Position? |
named |
Default Value |
none |
Accept Pipeline Input? |
false |
Accept Wildcard Characters? |
false |
-Profile<Microsoft.Azure.Common.Authentication.Models.AzureProfile>
Specifies the Azure profile from which this cmdlet reads. If you do not specify a profile, this cmdlet reads from the local default profile.
Aliases |
none |
Required? |
false |
Position? |
named |
Default Value |
none |
Accept Pipeline Input? |
false |
Accept Wildcard Characters? |
false |
-ResourceGroupName<System.String>
Specifies the name of the resource group in which this cmdlet creates the server.
Aliases |
none |
Required? |
true |
Position? |
1 |
Default Value |
none |
Accept Pipeline Input? |
true(ByPropertyName) |
Accept Wildcard Characters? |
false |
-ServerName<System.String>
Specifies the name of the new server.
Aliases |
none |
Required? |
true |
Position? |
named |
Default Value |
none |
Accept Pipeline Input? |
false |
Accept Wildcard Characters? |
false |
-ServerVersion<System.String>
Specifies the version of the new server. Valid values are: 2.0 and 12.0.
Specify 2.0 to create a version 11 server, or 12.0 to create a version 12 server.
Aliases |
none |
Required? |
false |
Position? |
named |
Default Value |
none |
Accept Pipeline Input? |
false |
Accept Wildcard Characters? |
false |
-SqlAdministratorCredentials<System.Management.Automation.PSCredential>
Specifies the SQL Database server administrator credential for the new server. To obtain a PSCredential object, use the Get-Credential cmdlet. For more information, type Get-Help Get-Credential
.
Aliases |
none |
Required? |
true |
Position? |
named |
Default Value |
none |
Accept Pipeline Input? |
false |
Accept Wildcard Characters? |
false |
-Tags<System.Collections.Generic.Dictionary`2[[System.String, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089],[System.String, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]]>
Specifies a dictionary of tags that this cmdlet associates with the new server.
Aliases |
none |
Required? |
false |
Position? |
named |
Default Value |
none |
Accept Pipeline Input? |
false |
Accept Wildcard Characters? |
false |
Inputs
The input type is the type of the objects that you can pipe to the cmdlet.
- System.String
Outputs
The output type is the type of the objects that the cmdlet emits.
- System.Object
Notes
- This cmdlet supports the common parameters: Verbose, Debug, ErrorAction, ErrorVariable, WarningAction, WarningVariable, OutBuffer, PipelineVariable, and OutVariable. For more information, see about_CommonParameters.
Examples
Example 1: Create a dAzure SQL Database servera d
This command creates a version 12 Azure SQL Database server.
PS C:\> New-AzureSqlServer -ResourceGroupName "ResourceGroup11" -Location "Central US" -ServerName "Server01" -ServerVersion "12.0"