SQL Compare 15 - sp_rename for columns is after stored procedure updates
cmbergin
Posts: 1 New member
in SQL Compare
We maintain a database scripts folder (with Redgate schema) in source control to help with database change management. I renamed a column in a couple of my tables. There were a number of stored procedures referencing that column that were also updated to use the new column name. These changes were all made in the scripts folder.
When deploying to my development database instance, the Automap feature detected the column rename, which is great, but the generated deployment script places the CREATE OR ALTER PROCEDURE statements before executing sp_rename on the columns, which causes deployment to fail.
Obviously, I can just move the commands around within the script for now, but it would be nice to get that adjusted.
When deploying to my development database instance, the Automap feature detected the column rename, which is great, but the generated deployment script places the CREATE OR ALTER PROCEDURE statements before executing sp_rename on the columns, which causes deployment to fail.
Obviously, I can just move the commands around within the script for now, but it would be nice to get that adjusted.
Tagged:
Answers
Thank you for your post. A support ticket has been opened for this issue so that we can gather a bit more information to troubleshoot.