Data-tier Applications feature of Microsoft SQL Azure

SQL Azure now supports Data-tier Applications which’re introduced with Visual Studio 2010 and SQL Server 2008 R2. “Here’s a quick tour feature: Launch Visual Studio 2010 and create new Data-tier Application project; Import my pubs database from local instance; Set my deployment properties to point to my SQL Azure account; Build and deploy from Visual […]

SQL Azure now supports Data-tier Applications which’re introduced with Visual Studio 2010 and SQL Server 2008 R2. “Here’s a quick tour feature: Launch Visual Studio 2010 and create new Data-tier Application project; Import my pubs database from local instance; Set my deployment properties to point to my SQL Azure account; Build and deploy from Visual Studio. It’s that simple! So what does this look like?

In the Data-tier Application project, the connection string is exactly same as a local instance except server name is my SQL Azure server. I select build & deploy. System built DACPAC, connected to SQL Azure instances, and deployed Data-tier Application. New database, Pubs-Azure, appears in my SQL Azure admin dashboard. Connecting SQL Server 2008 R2 Management Studio to my SQL Azure instance I see databases as well as meta-data for Data-tier Application. With VS 2010, SQL Server 2008 R2 Management Studio and latest release of SQL Azure we’ve symmetrical experience for creating, registering, & deploying Data-tier apps. Unfortunately at this time we don’t support upgrading Data-tier app on SQL Azure, as we do with on-Premise install of SQL Server. To move to your database to next version of your app you’d deploy side-by-side and migrate your data using favorite data migration tool. In addition, if you want to share database schema you no longer have to provide bunch of Transact-SQL scripts. You can give DAC Pack file, containing name of the app, version, and database schema definition. This’ll make management of apps, including deployment much simpler!,” explains Dan.

More Screenshots: SQL Azure Now Supports Data-tier Applications