DAC and Sql Scripts

Question

Hi Experts,

 

What's the main difference DAC (Data Tier application)and creating Sql Scripts?

 

 

---

Manish

Answer 1

Start from here http://www.brentozar.com/archive/2009/08/sql-server-2008-r2-the-dac-pack/

---

Balmukund Lakhani | Please mark solved if I've answered your question, vote for it as helpful to help other user's find a solution quicker
--------------------------------------------------------------------------------
This posting is provided "AS IS" with no warranties, and confers no rights.
--------------------------------------------------------------------------------
My Blog | Team Blog | @Twitter

Answer 2

The main purpose it to manage or drop |create|rename functionlity from one package .dac. Am i right? it can be created from VS 2010 and SSMS 2010. in VS 2010, when we create , it can be deployed to any sql server 2008 R2(>=). But in VS2010 in sql server data tier project, we can't save data. then it's useless. or it means we can create skeleton in VS2010 only.

---

Manish

Answer 3

Please refer http://msdn.microsoft.com/en-us/library/ee240739.aspx

A data-tier application (DAC) is an entity that contains all of the database and instance objects used by an application. A DAC provides a single unit for authoring, deploying, and managing the data-tier objects instead of having to manage them separately. A DAC allows tighter integration of data-tier development with the development of the associated application code. It also gives administrators an application level view of resource usage in their systems.

 

Answer 4

But here my question is : It only manages Object definition like table create{Create table}. But How it manages Data in itself{records in a table}.

can we manage data in ItSelf?

---

Manish