Pretty trivial to implement but would be a huge help to have a simple tool to view and manage firewall rules.
Here are the system extended stored procedures:
Here are some samples:
--create a firewall rule for a single IP address
exec sp_set_firewall_rule N'DevComputer','184.108.40.206','220.127.116.11'
--create a firewall rule for Microsoft services and Windows Azure services
exec sp_set_firewall_rule N'MicrosoftServices','0.0.0.0','0.0.0.0'
--delete a firewall rule
exec sp_delete_firewall_rule N'DevComputer'
--get a list of the firewall rules
select * from sys.firewall_rules12 votes
Add functionality for SQL Database Editor i.e. user can edit database and its objects just like SQL Server Management Studio.32 votes
Managing SQL Azure logins is currently a manual task done via transact SQL scripts run from within SQL Management Studio. It's difficult to manage which users have certain roles or access to particular schemas as well as basic object permissions.
It would be great to have the ability manage your SQL Azure logins via Cerebrate Azure Management Studio and have a nice, clear and easy to read overview.99 votes
There should be a ability to Restore from a bacpac file. Either by right click on the bacpac or menu.. restore from container bacpac to SQL Azure DB (New or overwrite) or from bacpac to SQL Server 2012.18 votes
It would be great if I could backup my Windows Azure SQL Databases using Azure Management Studio.115 votes
Basic support is coming soon for database management.
- Don't see your idea?