Options
Unique constraint name
AbelG
Posts: 3 New member
Hey everyone,
I would like to ask if someone here experienced an issue when creating UNIQUE CONSTRAINT and deploying it through SQL Change Automation.
The issue is SQL Change Automation does not follow the specified name in the deploy-once script. It only happens when creating UNIQUE CONSTRAINTS. We've tried creating an INDEX and the name is being assigned properly.
I would like to ask if someone here experienced an issue when creating UNIQUE CONSTRAINT and deploying it through SQL Change Automation.
The issue is SQL Change Automation does not follow the specified name in the deploy-once script. It only happens when creating UNIQUE CONSTRAINTS. We've tried creating an INDEX and the name is being assigned properly.
Tagged:
Answers
We are currently on SQL Change Automation version 4.2.20168.20590
We're not aware of any issues when deploying UNIQUE constraints.
I will get in touch with you through our support systems to see if we can get more details regarding this.
Product Support Engineer
Redgate Software Ltd
Please see our Help Center for detailed guides on how to use our tools