SQL Server – Reading BACPAC Files

If you have been reading my blog for a while now you would know that a common technique to move to Azure SQL DB is to use BACPAC files. Just a reminder, see the below image.


I had a bacpac file but I forgot about the contents, partly because of the bad naming convention, test.bacpac isnt great right? However for whatever reason you may  want to know what tables are within the bacpac, this being the main point of the post!

If you do a little “editing” with file extensions you will be able to see what the bacpac file contains. Let’s get to it. As you can see below I have a test.bacpac file.

Step 1 – Take a copy of the file and change the extension to .ZIP.


Step 2 – Extract the ZIP file to whatever location you desire.


Step 3 – View the folder structure and navigate to the Data folder.


Step 4 – The table list is here.


Very cool right? Just to prove it is the correct list this is my view of the tables via SSMS.





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 )

Facebook photo

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

Connecting to %s