630
Part V: Enterprise Data Management
FIGURE 23-10
Indicating to run the package immediately and saving the package with encryption.Best Practice
To copy the full database or multiple databases, use the Copy Database Wizard instead of the Impor t
and Export Wizard.Data-Tier Application (DAC)
Data-Tier Applications (DAC) were fi rst introduced in SQL Server 2008 R2. A DAC defi nes all
the database objects (such as tables and views) as well as instance objects associated with a
database (such as logins).This feature enables developers to build their database projects and encapsulates all the
necessary database resources into a DAC package deployment fi le. The DAC fi le can then be
deployed by administrators.c23.indd 630c23.indd 630 7/31/2012 9:25:23 AM7/31/2012 9:25:23 AM
http://www.it-ebooks.info