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

Synchroinze with Drop and Create instead of Alter

kcassatakcassata Posts: 2
edited March 29, 2005 11:04AM in SQL Compare Previous Versions
Hello, I am hoping you can help me with a problem that I am having with your software tool and our company's standards. The SQL DBA's at our company require that we do drop and create's and not alter's so that they can get a history of the last change to a stored proc. This means I also need to readd permissions at the end which is not required for alters.

That being said, I am a software developer required to adhere to this standard. Is there any way that this process can be automated with the synchronize steps built into red-gate or else any way that I can write something to make this work with an API.

Thanks in advance, Kevin

Comments

  • Options
    Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
    Hello Kevin,

    Thanks for your post. In this version of SQL Compare, there is no way to force the software, even using the API, to drop the stored procedures. They will always be altered.

    You would need to get SQL Compare to ignore the stored procedures for synchronization and then manually script the dropping and re-creating of stored procedures.
This discussion has been closed.