Microsoft released the CTP of Project Code-Named “Houston,” a lightweight and easy to use database management tool for SQL Azure databases. It’s designed specifically for Web developers and other technology professionals seeking a straightforward solution to quickly develop, deploy, and manage their data-driven applications in the cloud. Project “Houston” provides a web-based database management tool for basic database management tasks like authoring and executing queries, designing and editing a database schema, and editing table data.
Here’re some videos to get you started:
Tables demonstrates how use Project “Houston” to create and modify a table in an existing SQL Server database:
Queries describes how to use Houston to create, modify, execute, save, and open a Transact-SQL query:
Views shows how to use Houston to create, select, and modify views:
Stored procedures shows how to use Houston to create, select, and modify stored procedures.
You can access “Houston” from SQL Azure Labs, and make sure that you check the “Allow Microsoft Services” checkbox in your firewall to allow “Houston” to communicate with your databases.