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.)
12 comments
-
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).
-
Tim
commented
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
@Roopish, @Dan
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.
-
pmonte
commented
The GUI to Edit and Design would be really welcome!
-
Jason R. Craig
commented
I NEED NEED NEED NEED the database designer tools!!!!
-
crpietschmann
commented
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