Managing the Core Database Engine - Microsoft SQL Server 2008 R2 Administration - page 100

10. In the Specify Import Options page, click Import from an existing instance of
SQL Server.
11. Then, type a value in Connection string for the SQL Server instance, or click Edit to
configure a connection.
12. After that, choose a database from the Database name list. When you are done,
click Next.
13. The Summary page lists all database objects that are supported by a DAC.
14. If any objects are not supported, the import cannot be performed successfully. If all
objects are supported, click Next.
15. The Import Objects page tracks progress while the wizard creates the SQL scripts for
the database objects and loads them into the project.
16. The final step is to click Finish to close the wizard.
We will now go through the deployment using SQL Server Management Studio tool to deploy
data-tier application components:
1. Start the Import Data-tier Application Wizard.
2. Right-click the project node and then click Import Data-tier Application.
3. In the Specify Import Options page, click Import from a data-tier application
package and then click Browse to select the DAC package file; click Next to continue.
4. The final confirmation of the list of database objects in the DAC package is shown in
the Summary page.
5. The Import Objects page tracks progress as the wizard creates the SQL scripts for
the database objects and loads them into the project.
6. Click Finish to close the wizard when the page completes.
After a data-tier application project has been created, users
can add SQL Server database objects as well as instance
objects (such as logins) to the project. Objects can be added
by using built-in templates or by writing Transact-SQL code
directly in the editor, without the use of templates.