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.)
SQL Server Management Studio is crippled to the point of making it almost pointless when working with Azure.
Why do we lose all of the "SELECT TOP 1000 ROWS" OR "EDIT TOP 200 ROWS" type options which are really handy?
Same for modify stored procedure, add users etc etc.
Also taking the database offline/dropping connections.
I'm not a DBA so I don't want to search the internet for complicated SQL statements to do this stuff that is normally part of the SSMS.
Please add this in so SQL Azure DBs aren't such a pain to manage.
I really miss intellisense when I connect to my SQL database in Azure with SQL Management Studio.
Currently any SQL work needs to be run using TSQL, add support for using the designers to modify tables, run procedures etc.
SQL Azure database projects do not build correctly in TFS Preview build servers. They error out saying the project type is not supported. Please add support for them! Thanks!
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]
In a DB-as-a-service model, that Azure SQL database is, full management studio support isn’t something that we can promise or deliver on in the short/medium term.
We do have two great solutions for SQL in Windows Azure. SQL Server in a Windows Azure VM is the best choice for highest T-SQL compatibility. Azure SQL Database is the best choice when writing new apps, or when existing apps can be modified to run with the subset of T-SQL that Azure SQL Database supports.
I would say four years to decide not to do anything is a little on the slow side...
James D. Schwarzmeier commented
Thanks for the update.
While I agree it would not make sense to deliver 100% of the typical SSMS functionality, there are still a lot of things that should be fairly direct to implement: intellisense, the table designer, generating schema diagrams, etc.
I think much of the frustration behind this request isn't that SSMS has 100% parity with on-premises SQL databases, but rather that there are so many fairly basic things that seem like they should be straightforward but have gone ignored for years.
Doug Rubino commented
I really miss it too. Please move this item off the backlog. Intellisense makes the Azure SQL Database user experience so much better in management studio.
I'm using ssms 2012 and i don't have the table designer ALTER option is disabled on context menus and EXEC as well. Is there anything i can do to make it work?
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.
Por Belmstedt commented
Don't forget "Edit top 200 rows". Top important!
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