Azure SQL database DACPAC creation

Question

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.

Answer 1

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://learn.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