Hi Amila Ariyasena •,
Welcome to Microsoft Q&A forum and thanks for using Azure Services.
As I understand, you are trying to modify to work with an Azure SQL Managed Instance database using Azure DevOps.
The issue might be due to timeout which could be handled by the ways as follows with respect to SqlPackage:
For issues related to timeouts, the following properties can be used to tune the connection between SqlPackage and the SQL instance:
-
/p:CommandTimeout=
: Specifies the command timeout in seconds when a query is executed. Default: 60 -
/p:DatabaseLockTimeout=
: Specifies the database lock timeout in seconds. -1 can be used to wait indefinitely, default: 60 -
/p:LongRunningCommandTimeout=
: Specifies the long running command timeout in seconds. The default value, 0, is used to wait indefinitely.
By default, SqlPackage sets the maximum server parallelism to 8. If you note low server resource consumption, increasing the value of the MaxParallelism
parameter may improve performance.
Reference doc: https://learn.microsoft.com/en-us/sql/tools/sqlpackage/troubleshooting-issues-and-performance-with-sqlpackage?view=sql-server-ver16
Make sure that the Managed Instance is configured correctly for handling large database deployments. This includes setting the correct timeout values for idle connections, configuring the maximum number of client connections, and setting any necessary security options such as SSL/TLS encryption.
Hope this helps. If this answers your query, do click Accept Answer
and Mark Helpful
for the same. And, if you have any further query do let us know.
Thanks.