As part of my learning and preparing for the exam AZ 303 - Microsoft Architecture Technologies, Its a sub topic under "Implement and manage Data platform".
Publish an Azure SQL Database:
The word "Publish" being used because the nature of the Azure SQL Database.(Service). Essentially publish means, updating your Azure SQL database's schema and data.
Before publishing (updating the Azure SQL), we should know steps to creating and deploying the Azure SQL.
Publishing the Azure SQL Database supports the DevOps cycle within your project.
Different types of approaches to create and deploy the Azure SQL.
- DACPAC (Data Tier Application Package - Reference )
It focusing on capturing and deploying the schema including updating an existing database. Best fit for DevOps. Developer can easily deploy the package from development to production with version controls.
SQL Script
To run the SQL Script against Azure SQL , you need to create the firewall rules in order to execute the script by Azure Pipeline agent.
Classic PowerShell (Windows based)
Azure Pipeline based on YAML (executing the SQL Scripts)