Constraints and Indexes are not removing by Redgate source control deployment process

pramodcrowepramodcrowe Posts: 3 New member
edited September 6, 2021 11:07AM in SQL Source Control

In the initial version of the table creation, I created a foreign key on the table but the explicit name is not given for the foreign key. DB has given it a random name. In the later version, I explicitly renamed the same foreign key. When we tried deploying the latest to the DB using Redgate, it tried dropping the foreign key unsuccessfully and the deployment failed. So, I removed the foreign key manually and went ahead with the deployment process. This cant be an ideal solution for the production scenario. So, please help us in this scenario.
[4:35 PM] Battula, Amitha
On how to rename the DB objects successfully without manual intervention


  • The drop is probably unavoidable but I wouldn't expect the deployment to fail, can you please give us more details regarding the error you have received?

    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.