SQL Server 2008 R2 comes with a new feature called Data-tier application (DAC). Thou it's an Enterprise Edition only feature and has limitations on objects that can be scripted in the .dacpack file that gets created out of Visual Studio 2010, it's a great feature to have, at least for the application developers as it provides them a nice control without getting involved into the complexity of T-SQL to deploy their database side logic and create an installer package out-of-the-box from Visual Studio.
Watch the video tutorial and learn how to develop data-tier applications using Visual Studio 2010 and SQL Server 2008 R2.
Today Visual Studio 2010 and .NET Framework 4 Release Candidate is available to MSDN subscribers and can be downloaded from here.
Also check out Entity Designer Database Generation Powerpack which is a free add-in for Visual Studio 2010 and has some great features on the lines of database generation technologies.
Article 
No comments:
Post a Comment