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
Comments
1 comment
-
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?
Add comment
Please sign in to leave a comment.