Deploy

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

One Response to Deploy

  1. No matter what I do I can’t get the return status for a single backup using -R (-RequestID). This was fine, as I am poarsing the full output to pick the status out. However now I’m in trouble: “The maximum message size quota for incoming messages has been exceeded. To increase the quota, use the MaxReceivedMessageSize property on the appropriate binding element.” This is on the North American datacentre (Chicago), Asia and EME are working fine. Any idea when either will be fixed? Ideally making the -R parameter work would be the best, as without this I have to keep retrieving the whole backup history and parsing that. Cool tool, just needs that last little bit to make it ready for the big time! Thanks. James

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: