So far we’ve covered some different methods of creating a DACPAC. Well once you have a compiled or extracted DACPAC the first interesting service you can use is the deploy service. The deploy service will create a database with the specified settings and then create all of the objects defined in the DACPAC inside the new database. Once finished, the database is ‘registered’ (see the next post) as a Data-tier Application. Think of the DACPAC as a database definition MSI and the deploy service as a DACPAC installer.
Here’s a quick walkthrough of deploying a DACPAC to a new database:
For more information on how deployment is actually accomplished, see the Upgrade post.
Final note, the deploy service will create your schema in:
- SQL Server 2005 SP4 and above
- SQL Server 2008 SP2 and above
- SQL Server 2008 R2
- SQL Server Code Name “Denali”
- SQL Azure