.png?width=100&auto=webp&quality=80&disable=upscale "Picture of John Savill")
.png?width=400&auto=webp&quality=80&disable=upscale "John Savill")
Sign up for the ITPro Today newsletter
Stay on top of the IT universe with commentary, news analysis, how-to's, and tips delivered to your inbox daily.
Creating a SQL Server Data-Tier Application
Like IIS web packages, many deployment services have the ability to deploy SQL Server Data-Tier Applications (DAC) which enable entire SQL server
John Savill
January 15, 2013
1 Min Read
Q: How do I create a SQL Server Data-Tier Application (DAC) from SQL Server?
A: Like IIS web packages, many deployment services have the ability to deploy SQL Server Data-Tier Applications (DAC), which enable entire SQL Server databases and applications to be deployed to servers in an automated fashion. This can be used as part of a complete server build--for example, when using Service Templates in Virtual Machine Manager or if a developer just wants to give a database to a DBA for easy deployment. To create a DAC, perform the following:
Launch the Microsoft SQL Server Management Studio application.
Navigate to the database you want to export.
Right-click the database and select Extract Data-tier Application... from the Tasks menu.
Click Next to the introduction screen of the wizard.
Enter properties for the DAC package, including where to save it to, and click Next.
Review the summary, then click Next to begin the creation. Once complete, click Finish.
About the Author
You May Also Like
.png?width=700&auto=webp&quality=80&disable=upscale)