Support CREATE OR ALTER instead of CREATE
Sometimes, we create the migration script using SQL Comapare and schedule it for deployment. Then, it turns out, some feature has to to production ASAP, so I create the procedure there manually.
I would love the script not to fail in that case, ie. to ignore and overwrite the existing procedure.
27
votes
Fran Tonkovic (frandroid)
shared this idea
-
James Menzies
commented
Yup. Just integrating with a new project and SQL Compare thinking that CREATE PROC and CREATE OR ALTER PROC is very annoying.