[This article was contributed by the SQL Azure team.]
This is the second post in a series about getting started with Microsoft Project Code-Named “Houston” (Houston) (Part 1). In part 1 we covered the basics, logging in and navigation. In this post we will cover how to use the table designer in Project Houston. As a quick reminder, Microsoft Project Code-Named “Houston” (Houston) is a light weight database management tool for SQL Azure and is a community technology preview (CTP). Houston can be used for basic database management tasks like authoring and executing queries, designing and editing a database schema, and editing table data.
Currently, SQL Server Management Studio 2008 R2 doesn’t have a table designer implemented for SQL Azure. If you want to create tables in SQL Server Management Studio 2008 you have to type a CREATE TABLE script and execute it as a query. However, Project Houston has a fully implemented web-based table designer. Currently, Project Houston is a community technology preview (CTP).
You can start using Houston by going to: http://www.sqlazurelabs.com/houston.aspx (The SQL Azure labs site is the location for projects that are either in CTP or incubation form). Once you have reached the site login to your server and database to start designing a table. For more information on logging in and navigation in Houston, see the first blog post.
Once you have logged in, the database navigation bar will appear in the top left of the screen. It should look like this:
To create a new table:
The star next to the title indicates that the table is new and unsaved. Houston automatically adds three columns to your new table. You can rename them or modify the types depending on your needs.
If you want to delete one of the newly added columns, just click on the column name so that the column is selected and press the Delete button in the Columns section of the ribbon bar.
If you want to add another column, just click on the + Column button or the New button in the Columns section of the ribbon bar.
Here is a quick translation from Houston terms to what we are used to with SQL Server tools:
When you are ready to commit your table to SQL Azure you need to save the table using the Save button in the ribbon bar.
We’re aware of a few limitations with the current offering such as creating tables with multiple primary key fails, and some renaming of tables and column and causes errors when saving. As with any CTP we are looking for feedback and suggestions, please log any bugs you find.
Again, since this is CTP Project “Houston” is not supported by standard Microsoft support services. For community-based support, post a question to the SQL Azure Labs MSDN forums. The product team will do its best to answer any questions posted there.
To log a bug about Project “Houston” in this release, use the following steps:
To provide a suggestion about Project “Houston” in this release, use the following steps:
If you have any questions about the feedback submission process or about accessing the portal, send us an e-mail message: firstname.lastname@example.org.
This is just the beginning of our Microsoft Project Code-Named “Houston” (Houston) blog posts, make sure to subscribe to the RSS feed to be alerted as we post more information.