how to extract dacpac to schema objects programmatically

Question

HI All,

I have a dacpac. I would like to extract tables, views and all other schema objects.

Is there a function in sqlpackage, which can accomplish this task.

TIA

Answer 1

just change the file extension to .zip, and unzip. you will see all the xml files

Answer 2

Thanks, Bruce. I am seeing 4 xml files. I am expecting to see same folder structure as we see when we open in vs.net

views,stored proc, tables etc

Origin.xml

Model.xml

DacMetadata.xml

ContentTypes.xml

Thank you!

Answer 3

Hi SKG •,

Thanks for posting this question on Microsoft Q&A forum.

As I understand, you want to extract dacpac.

Please refer to https://stackoverflow.com/questions/57402985/how-do-i-extract-a-database-schema-from-a-dacpac-file

and

https://learn.microsoft.com/en-us/azure/azure-sql/database/database-import?view=azuresql-mi&tabs=azure-powershell

You can extract it using SSMS or Import in Azure Portal. Do let us know if you face any issue. Thanks.