Search code examples
azure-synapsesqlpackageazure-synapse-pipeline

Sqlpackage.exe stucks on initialization

Am using sqlpackage.exe for synapse deployment, version 162.0.52.1.

During the initialization, it stucks at this step:

enter image description here Does anybody know, how to solve it?

Solution

  • There were to less RAM on agent for the schema comparison there.

    The schema comparison step of sqlpackage.exe increased the RAM utilization from 3GB to 14GB: enter image description here

    In this case, there was a Azure DevOps Agent used for the execution. By default, there are only 7GB RAM available for hosted Agents: enter image description here

    https://learn.microsoft.com/en-us/azure/devops/pipelines/agents/hosted?view=azure-devops&tabs=yaml#hardware