SQL azure (6) Use Project Houston to manage SQL azure

This chapter is a supplement to SQL azure's use of SQL Server Management studio to connect to SQL azure.

 

On the Windows azure user management page, select an SQL azure database and click the manage button on the toolbar to go to the project Houston Management page.

Project Houston is a Silverlight-based SQL azure Database Manager. Its Interface and functions are similar to SQL Server manaement Studio (SSMs) and are mainly used to manage tables, views, and stored procedures of SQL azure databases. However, SSMs can only be operated through a T-SQL, while project Houston provides a visual approach.

After entering the project Houston, you must first enter the user name and password

After successful logon, the main interface of the Project Houston is displayed. The left-side Navigation Pane lists all tables, views, and stored procedures in the current database. The intermediate section displays the current database configuration information, including the character set, Creation Time, And version information, as well as the current database capacity and usage. The Toolbar contains operations on various databases.

 

Select "design" --> "create table" in the navigation bar ".

You can create a table in SQL azure and add/delete fields, set the type, primary key, and whether the fields are empty.

You can also edit an existing data table.

You can edit and delete existing columns.

As you can see, project Houston provides developers with the function of graphical Management of SQL azure. It can manage tables, views, and stored procedures in the SQL azure database, or view records in SQL azure.