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.