Azure SQL Database
An Azure relational database service.
SqlPackage Parameter `/p:RestoreSequenceCurrentValue` Not Working in Azure DevOps Release Pipeline
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(304, 42%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVP%3C/text%3E%3C/svg%3E)
Vinci Poon
1
Reputation point
Hi,
An Azure DevOps release pipeline is being used to deploy a DACPAC to an Azure SQL Database using the Azure SQL Database deployment task (version 1.*). To maintain the existing sequence current value, the parameter /p:RestoreSequenceCurrentValue=False was added to the "Additional SqlPackage.exe Arguments" section. However, after deployment, the sequence current value is still being restored to 1.
Azure SQL Database
Community Center | Not monitored
Community Center | Not monitored
Tag not monitored by Microsoft.
{count} votes
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(198.4, 69%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESR%3C/text%3E%3C/svg%3E)
Sai Raghunadh M 4,570 Reputation points Microsoft External Staff Moderator2025-01-27T10:49:26.69+00:00 Hi @ Vinci Poon
Welcome to the MS Q&A platform.
The query posted by you is not supported in the Q&A forum. I would request you post your query in the Azure DevOps forum
https://developercommunity.visualstudio.com/AzureDevOps
This will assist you with a faster reply to your query.
Hope this will help.
Thanks.
Sign in to comment
Sign in to answer