I am using SQL Server database deploy task to deploy sql scripts to an on-prem SQL Server database. But the downside I see to this is I could only do 1 script at a time. This would work fine only when I have a small finite number of files but if the number of files increase this option would not scale up. What other options are available in Azure DevOps.

YAML:

steps:
- task: SqlDacpacDeploymentOnMachineGroup@0
  displayName: 'Deploy SQL Query'
  inputs:
    TaskType: sqlQuery
    SqlFile: '$(System.DefaultWorkingDirectory)myScript.sql'
    ServerName: 'localhost'
    DatabaseName: 'DB_Name'