Tuesday, 12 July 2011

SQL Server Data-tier Application (DAC) or Sql Server Database Project - Visual Studio 2010

I am trying to figure out which one to use and when.

I found out via this post that:
  • The SQL Server Data-tier Applciation (DAC) project type *only* works with SQL Server 2008 R2 databases
Although this instance of SQL Server is available, this seems like quite a restriction - i'm tempted to instantly dismiss this project type in favour of the Sql Server Database Project.

I found out via this post that:
  • The Sql Server Database Project (*.dbproj)  "...will import all objects from your database as SQL scripts. This can be stuck into source control."

1 comment:

  1. DAC supports SQL Azure, 2008R2, 2008 SP2 and above, and 2005 SP4 and above.