What are the challenges you face when working across database platforms? Take the survey

Option to Drop/Create Procedures instead of Alter

Grant FritcheyGrant Fritchey Posts: 72
edited December 11, 2009 1:35PM in SQL Compare Previous Versions
I've looked around and I can't find this, so I'm assuming it's not there. Please correct me if it is. Is there a mechanism to force the scripts to drop procedures and recreate them rather than running ALTER statements?

The reason for this is because we have a large number of databases running in Express. We have a master database that they are all supposed to have an exact copy of, but sometimes, well, the copy isn't exact. If they have an exact copy, ALTER will work great. But if the copy is off, DROP & CREATE will work better.


Sign In or Register to comment.