Programmatically Managing SQL Azure using REST API

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 !!!

Author: Arunraj

I am a Microsoft Certified Technology Specialist (Database Developer). I work on SQL Server programming since SQL Server 7.0 specializes in SQL Server Programming and Performance Tuning and has 14 years of hands-on experience. I hold a Master Degree in Computer Applications. I am also part of NJSQL User Group and Northern New Jersey .Net User Group. View all posts by Arunraj