How to create a DacPac

Over coffee with friends we got talking about dacpacs and other stuff.

Later, Friend1 still had questions over skype about how to install it and such. I replied but he was gone. So I figured, I better send him some instructions and screenshots by email.

From: Fleitas, Hiram
Sent: Tuesday, January 10, 2017 5:52 PM
To: Friend1
Cc: Friend2
Subject: dacpac

Friend1, Here’s a step by step.

1

2

3

Don’t worry about the next two screenshots if you don’t check the Add to Subversion option when creating the new project.

4

5

Open Solution Explorer

6

From here you can develop a new project or tie this project into an existing environment, ie. import. If you choose to import and make changes, then hit F5 (or click Start) and the output frame will display the log and you will see a .dacpac file is created on your local project. That file can be ran on the remote server and changes will be applied.

79

Open solution explorer again, double click to open the object desired to change or create a new object by right click Add…

10

11

Make change, you can see I just added a new comment and hit F5 (Start). You will see the dacpac file created in the project path.

17

If you go to that folder it will contain a .sql file with the changes, the .dacpac can be extracted and the model.sql file will contain the imported schema (ie. previous version) before the intended changes.

13

14

15

You can also right click the project, hit Publish, the Output shows the dacpac gets build and you can publish to a desired target database connection as well as a data-tier application. Check out the checkbox Block publish when database has drifted from registered version. Pretty self-explanatory. Awesome!

16

In this initial debug demo I see the model.sql file has the headers of the objects stripped off so just FYI. I wouldn’t want to deploy this. It’s actually used for the schema compare to check if the target has any differences and block the deployment.

But the idea is that you can develop for a desired target and hand off the package to apply the changes.

This is a consolidated model of having to hand off multiple scripts. The .dacpac will contain the contents of the entire project, not just the changes.

APIs exists to auto deploy/rollout the .dacpac files to remote svrs.

Thank you,
Hiram

Advertisements

One thought on “How to create a DacPac

Leave a Reply

Please log in using one of these methods to post your comment:

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