What are the challenges you face when working across database platforms? Take the survey

Unique constraint name

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.



  • Options
    AbelGAbelG Posts: 3 New member
    Additional info:
    We are currently on SQL Change Automation version 4.2.20168.20590
  • Options
    Sergio RSergio R Posts: 610 Rose Gold 5
    Hi Abel,

    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
Sign In or Register to comment.