In May 2011 SQL Azure Service Update 7, SQL Azure Management REST API was released.
SQL Azure Management REST API can be used for
- Create SQL Azure server – http://msdn.microsoft.com/en-us/library/gg715274.aspx
- Delete SQL Azure Server – http://msdn.microsoft.com/en-us/library/gg715285.aspx
- Reset Administrator Password for SQL Azure Server – http://msdn.microsoft.com/en-us/library/gg715272.aspx
- Get List of SQL Azure Servers available in the subscription – http://msdn.microsoft.com/en-us/library/gg715269.aspx
- Create Firewall Rules for specified SQL Azure Server – http://msdn.microsoft.com/en-us/library/gg715280.aspx
- Delete Firewall Rules for specified SQL Azure Server – http://msdn.microsoft.com/en-us/library/gg715277.aspx
- Get List of Available Firewall Rules for specified SQL Azure Server – http://msdn.microsoft.com/en-us/library/gg715278.aspx
- Currently it support Synchronous calls, there is no support Asynchronous calls.
All calls should be authenticated using X.509 Certificate and this certificate should be added as Management Certificate in Management Portal
Please read this article on How to create a Certificate http://msdn.microsoft.com/en-us/library/gg432987.aspx
Hope you all find this information useful !!!
SQLXpertise 