SQL Management studio for Azure & Editing RRS feed

  • Question

  • I am transitioning from a dedicated server sql instance to Azure and beginning to realize how spoiled I have come to having the complete SQL Management Studio to edit tables, indexes and such. So my question when will we get those features for editing SQL Azure databases? And is there an alternative that we can use for now?
    Tuesday, July 6, 2010 5:50 PM


All replies

  • I too would like to know how to add or modify fields in a table in a SQL Azure database.  How is this done?  I see that I can view my Azure database from within SQL Server 2008 R2 Express.  But I see no option there for going into design mode.  How do you make changes to a SQL Azure database table? 
    Wednesday, July 7, 2010 12:58 AM
  • Design mode (using GUI for editing) is presently limited to deleting only. Time you brush up a few T-SQL vocabulary and usage. There is the SQL Azure template available in SSMS.

    You can use ADD, REMOVE columns using Alter Table statements.

    Wednesday, July 7, 2010 1:21 AM
  • Hi,

    Currently, we don’t have this GUI feature when working with SQL Azure databases using SQL Server Management Studio 2008 R2. As a workaround, we can use T-SQL statements to manage our SQL Azure databases.

    I don’t know when we will have it but you can vote for the following suggestion in our SQL Azure Feature Voting Forum:


    I think this feature will be included in a future release.

    Please remember to mark the replies as answers if they help and unmark them if they provide no help.
    Welcome to the All-In-One Code Framework! If you have any feedback, please tell us.
    Wednesday, July 7, 2010 5:10 AM
  • I'd recommend keeping on on-prem version of the DB schema. With this, you can attach to it, make changes with the GUI, and then export "update scripts" which you should then be able to run on SQL Azure.

    Personally, I recommend keeping a copy of the schema on-prem anyways and using change scripts to help with versioning. :)

    • Proposed as answer by Writs Monday, July 19, 2010 9:37 AM
    Wednesday, July 7, 2010 6:08 PM
  • I think an on Prem version of the db is a good idea.  I am still new to Azure but my understanding is that it is fairly easy to make a backup of the Azure database to a local db.  It sounds like a good idea to make changes using the GUI locally.  However, getting those changes up to Azure (without affecting the data that's already in the db) sounds a little hairy. 

    I am an Access developer and literate in a number of areas, but not a SQL Server DBA.  I am familiar enough with SQL Server to create tables etc and use it as a back-end to other tools.  If I have to, I can brush up on T-SQL with regard to changing, adding or modifying fields, but Management Studio does spoil you.  I would like to find the easiest way possible, I'm not sure if what you're suggesting is any easier than just boning up on T-SQL.

    Sure hope SQL Azure will make this management studio addition in the futurel

    Wednesday, July 7, 2010 6:26 PM
  • essentially you'll be using the managment studio to do the t-sql for you. The upside is that you always will have a local version that's up to date as well as a set of versioning scripts that you can use to apply changes to your DB on.

    Either way, boning up on t-sql is something I'd recommend. You don't have to take it as far as being a DBA. But knowing your way around t-sql will help you be a better SQL Server developer. :)

    Monday, July 19, 2010 1:54 PM
  • Hi,

    Please take a look at Project Houston: https://manage.sqlazurelabs.com/ . I haven't tried it personally but from the blog post by David Aiken (http://www.davidaiken.com/2010/07/21/manage-your-sql-azure-databases-with-project-houston/ ), I believe it has GUI based editor for managing tables, views etc.

    Hope this helps.


    Gaurav Mantri

    Cerebrata Software



    • Marked as answer by Yi-Lun Luo Friday, July 30, 2010 9:31 AM
    Thursday, July 22, 2010 11:16 AM