2: Variables

Please note that you need the below variables created for this to work:

I recommend doing this by creating at least one Azure Pipelines variable group:

• agentpool - The name of the pool your local Azure DevOps Agent has been setup in
• BuildConfiguration - Configuration you want the build to be (e.g. Release)
• SQLPoolartifactname - Name you want to five the created artifact
• AzureSubscription - The Azure subscription you use, either it's full name or a service connection. However, if using the full name for the variable it cannot be secret. You will also need to give your pipeline permission when you first run it. I recommend creating a service connection in Project settings with an anonymous name instead of using full account details.
• SQLPoolEndPoint - Your serverless SQL Pool endpoint
• DestinationDB - The database you want the update deployed to in the serverless SQL Pool
• SQLPooluser - User name to connect to the dedicated SQL Pool endpoint, try and keep this secret
• SQLPoolpw - Password of above user, definitely keep this one secret
• DacpacFile - Name of the dacpac file, typically the same name as the sqlproj file (e.g. ServerlessSQLPool-HomemadeProject.dacpac )