How can we help you today? How can we help you today?

Synchroinze with Drop and Create instead of Alter

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
kcassata
0

Comments

1 comment

Sort by
  • Brian Donahue
    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.
    Brian Donahue
    0

Add comment

Please sign in to leave a comment.