How can we improve Windows Azure Data Management: SQL Database?

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.)

392 votes
Vote
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    I agree to the terms of service
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    anonymousanonymous shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →
    Haris MajeedAdminHaris Majeed (Admin, Microsoft Windows Azure) shared a merged idea: Support more functionality in SQL Server Management Studio  ·   · 
    Haris MajeedAdminHaris Majeed (Admin, Microsoft Windows Azure) shared a merged idea: provide sql server explorer for sql azure (like sql management studio)  ·   · 

    12 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      I agree to the terms of service
      Signed in as (Sign out)
      Submitting...
      • Richard JunestrandRichard Junestrand commented  ·   ·  Flag as inappropriate

        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 BTim B commented  ·   ·  Flag as inappropriate

        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 AdminAzure Admin commented  ·   ·  Flag as inappropriate

        @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?

      • Jason R. CraigJason R. Craig commented  ·   ·  Flag as inappropriate

        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.

      • crpietschmanncrpietschmann commented  ·   ·  Flag as inappropriate

        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.

      Feedback and Knowledge Base