SQL Azure Service Update 4 is now live with database copy, improved help system, and deployment of Microsoft Project Code-Named “Houston” to multiple data centers.
- Database copy allows you to make a real-time complete snapshot of your database into a different server in data center. This new copy feature is the first step in backup support for SQL Azure, allowing you to get a complete backup of any SQL Azure database before making schema or database changes to source database. Database copy provides an additional layer of backup in addition to the multiple copies of the individual data already maintained by SQL Azure with each database write. The MSDN Documentation with more information is entitled: Copying Databases in SQL Azure.
- Development: How-to Topics (SQL Azure Database) on MSDN Development Center.
- Check out Microsoft project Microsoft Project Code-Named “Houston”, a light weight web-based database management tool for SQL Azure.
Tables demonstrates how use Project Houston to create and modify a table in an existing SQL Server database.
Video Queries describes how use Project Houston to create, modify, execute, save, and open a Transact-SQL query.
Views shows how use Project Houston to create, select, and modify views.
Stored procedures shows how use Project “Houston” to create, select, and modify stored procedures.