Working with SQL Server deployment tasks

You need to use SQL Server commands to build and deploy SQL Server applications. There are many tasks that need to be completed to build SQL Server applications in Azure Pipelines; follow these steps to create a pipeline using SQL Server deployment tasks:

1. You can follow steps 1 to 4 as described in the Working with .NET Core CLI tasks section.
2. Rename the file as shown in the following screenshot:

Figure 5.18 – Renaming the file

3. Search for SQL Server database, select the SQL Server database deploy task, and enter the following:

   - task: SqlDacpacDeploymentOnMachineGroup@0
     inputs:
       TaskType: 'sqlQuery'
       SqlFile: 'migrate.sql'
       ExecuteInTransaction: true
       ServerName: 'localhost'
       DatabaseName: 'your_database'
      ...