DBAs and developers alike find it hard to effectively develop, deploy and manage a data-tier application throughout its lifecycle. SQL Server developers today want to create a data-tier application they can test, declaratively deploy across multiple instances while the system deals with version upgrades. SQL Server DBAs on the other hand want to know deployment requirements a priori and they too want the system to perform some of the mechanical upgrade operations instead of managing data-tier applications via a bunch of scripts. In this video we will dive into Microsoft’s investments in the SQL Server data-tier application space and demonstrate the concepts and tools that simplify development and deployment of data-tier applications using Visual Studio 2010 and SQL Server Management Studio in SQL Server 2008 R2.
NOTE: Visual Studio 2010 Beta2 currently supports deploying Data-tier applications only to SQL Server 2008 R2. Please download and install the upcoming CTP3 of SQL Server 2008 R2 in order to use Data-tier Application Projects in Visual Studio 2010 Beta2.