question

NandanHegde-7720 avatar image
0 Votes"
NandanHegde-7720 asked azure-cxp-api edited

Azure SQL database DACPAC creation

Hello Team,
Currently we are in a process of acquiring a 3rd party vendor and take over their data sources which include Azure SQL databases.
They did not maintain any code repo for the same and directly made changes via logging in the database.
So is there any way via which we can generate the DACPAC from the database and check it in TFS/GIT ?
Similar to how we can connect to SSIS/SSAS instance via visual studio and get their code.

azure-sql-database
5 |1600 characters needed characters left characters exceeded
Toggle Comment visibility. Current Visibility: Visible to all users

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

VaibhavChaudhari avatar image
0 Votes"
VaibhavChaudhari answered

In SSMS, connect to Azure SQL DB > Right click on it > Tasks > Extract data-tier application and follow the steps. It should generate .dacpac file.

Reference: https://docs.microsoft.com/en-us/sql/relational-databases/data-tier-applications/extract-a-dac-from-a-database?view=sql-server-ver15#UsingDACExtractWizard



You can also open VS > New project > SQL DB project and Import objects from Azure SQL DB by providing it's details

If the response helped, do "Accept Answer" and upvote it - Vaibhav

5 |1600 characters needed characters left characters exceeded
Toggle Comment visibility. Current Visibility: Visible to all users

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.