Azure SQL Database
Azure SQL APIs require user credentials in order to authenticate. These APIs will require on the user providing this information via a setting stored using "azure config" and passed with the --connectionKey parameter. Additionally the user can use --adminuser, --adminpassword and --server params explicitly.
##Common parameters Below is a list of common parameters that can be used across multiple cmds. A user can use either connectionKey or adminuser/adminpassword/server but NOT both.
- connectionKey - Points to a key in config which contains a connection string with userid, password and server name.
- adminuser - Administrator username
- adminpassword - Administrator password
- server - Database Server
- subscription - Specifies the subscription to use. (global for all cmds)
##database servers
azure sql server create [--administratorLogin*] [--administratorPassword*] [--location*]
create a new database server
azure sql server show [--name*]
display server details
azure sql server list
get the list of servers
azure sql server delete [--name*]
Deletes a server
##database
azure sql db create [--name*] [--adminuser] [--adminpassword] [--server] [--collation] [--edition]
Creates a new database instance
azure sql db show [--name*] --adminuser --adminpassword --server
Display database details
azure sql db list --adminuser --adminpassword --server
List the database
azure sql db delete --adminuser --adminpassword --server
Deletes a database
##firewall rules
azure sql firewallrule create [--server*] [--name*] [--startIp*] [--endIp*]
create a new firewall rule
azure sql firewallrule show [--server*] [--name*]
display a firewall rule
azure sql firewallrule list [--server*]
list a firewall rule
azure sql firewallrule delete [--server*] [--name*]
Deletes a firewall rule
[ ]: Parameter can be passed positionally
*: Required parameter