Comparing encrypted sprocs
When comparing databases with encrypted sprocs in version 4, it would just create an alter script for each encrypted sproc. This was fine and good because it didn't matter if it changed - it would alter it anyway. But with version 5 it now gives me a warning saying it won't alter encrypted sprocs and gives me no way to override this. This is causing a huge PIA because now we have to go through a lot of hoops to get these sprocs updated. It doesn't hurt to alter an unchanged sproc - there is NO reason or benefit for this new behavior! Please tell me how I can compare 2 databases where the database being updated has some of the sprocs encrypted and some not.
0 · Share on Twitter
This discussion has been closed.