Forum Discussion
Azure SQL Web Portal .dacpac Functionality
I've had so far success in creating SQL Server databases using .bacpac through the Azure Portal web interface. That said, what I need is a way to update said databases' structures using a .dacpac t...
Hi,
It doesn't seems the right direction to look for. A DACPAC is a package containing a new structure for the database. SSDT will make a schema compare between the DACPAC and the production database and generate the script you need to update the database structure. The generation of the script involves queries to the database schema, they are not heavy queries at all.
The script itself, once you decide to execute, will be executed on the Azure SQL DB, all the transformations will be made on the server side. There is not a huge amount of network traffic as you suggest that could cause a so terrible response time. Anyway, we are talking about DACPAC, updating only the structure, not a BACPAC, with the data.
This kind of compare can be made using Azure Data Explorer, Visual Studio, a stand-alone installation of SSDT and maybe even visual studio code.
This kind of deployment can be automated in Azure DevOps pipelines. There is a task to update an Azure SQL Database based on a DacPac.
Kind Regards,
Dennes
It doesn't seems the right direction to look for. A DACPAC is a package containing a new structure for the database. SSDT will make a schema compare between the DACPAC and the production database and generate the script you need to update the database structure. The generation of the script involves queries to the database schema, they are not heavy queries at all.
The script itself, once you decide to execute, will be executed on the Azure SQL DB, all the transformations will be made on the server side. There is not a huge amount of network traffic as you suggest that could cause a so terrible response time. Anyway, we are talking about DACPAC, updating only the structure, not a BACPAC, with the data.
This kind of compare can be made using Azure Data Explorer, Visual Studio, a stand-alone installation of SSDT and maybe even visual studio code.
This kind of deployment can be automated in Azure DevOps pipelines. There is a task to update an Azure SQL Database based on a DacPac.
Kind Regards,
Dennes