Full Management Studio Support
Currently you can only run queries against SQL Azure databases. It would be good to get the rest of management studio working (object explorer etc.)
There are things that I can't do through SQL Server Management Studio with my SQL Azure DB that I can do with a normal SQL Server DB. For example, in Azure I can't edit schema through the Management Studio UI. The “Design” option is not available. I have to run scripts to do it. There are many other tasks that are not available to Azure databases as well, like backup/restore and "Script Table As...". It’s not easy to take an existing database and migrate it over to SQL Azure. This should be seamless
[moved from Windows Azure feature voting]
Please provide functionality to view Sql Azure objects using sql management studio. This will speed up our development time so much faster!
[idea moved from Windows Azure feature voting]
Henri Koppen commented
intellisense, intellisense, intellisense!
Richard Junestrand commented
Since it is available (to some extent) in SQL Server Data Tools it shouldn't be too complicated to get at least the same functionality in SQL Server Management Studio. Please prioritize this. I (and possibly many with me) think it is better to work with the db from within Management Studio than from within Visual Studio).
Check out SQL Server Data Tools.
Tim B commented
I just connected to my SQL Azure database for the first time through SQL Server Management Studio, only to discover it doesn't support database diagrams.
Are you kidding me? I have to script each and every modification?
I'm not too far along in my project, I may just use an ordinary SQL Express DB. Given the prevalence of transient errors, this means it may make more sense to drop SQL Azure altogether.
Azure Admin commented
This feature is NOT available in SQL 2008 R2's Management Studio. Query Designer is not available, nor is the table designer. Its a pain in the ass typing out table alter scripts by hand. Query designer is a huge time saver as well. Does anyone know why this doesnt work out of the box?
David Bowler commented
Please add support for table designer and query designer!
Jason R. Craig commented
The tooling must be unified, there should be no differences in developing for the enterprise or the cloud. I would really like to have database designer diagram and the query designer.
The GUI to Edit and Design would be really welcome!
Jason R. Craig commented
I NEED NEED NEED NEED the database designer tools!!!!
I don't know what Roopesh and Dan are talking about, but Management Studio, as of 2008 R2, only has very minimal SQL Azure support. It would be nice if Management Studio had all the same features for SQL Azure as it does for SQL Server; at least mostly.
Roopesh Shenoy commented
Yeah im so happy this feature is added in R2.. :).. please close this, its done.
Dan Jones commented
This was added in SQL Server 2008 R2