Manage Azure SQL Databases

Question

For some reason the SQL Management Tool doesnt work with Azure SQL Databases. This is nothing short of painful if you use the designers and diagrams to design your database.

I'm sure I'm not the only one who has stumbled at this point and would like to know what tool I can use to visual design and maintain the database.

Stuart Ozer · Accepted Answer · 2014-09-25 02:46:24Z

2

SQL Server Management Studio supports Azure SQL DB. Step-by-step docs are here: http://azure.microsoft.com/en-us/documentation/articles/sql-database-manage-azure-ssms/

You will have problems if you have not configured firewall rules for your database to include your client IP range. What sort of errors are you experiencing?

answered Sep 25, 2014 at 2:46

Stuart Ozer

1,3947 silver badges7 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Dale Fraser Over a year ago

No it doesn't. It supports connections and lets you run SQL statements but doesnt support any of the design options. Which is very disapointing given its Microsoft Tool and Microsoft Service, where the same tool works with AWS RDS.

Dale Fraser · Accepted Answer · 2015-04-25 17:11:56Z

1

The latest update to SSMS supports full design and edit with a few minor things missing.

answered Apr 25, 2015 at 17:11

Dale Fraser

4,7687 gold badges43 silver badges76 bronze badges

Collectives™ on Stack Overflow

Manage Azure SQL Databases

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related