SQL Server Performance Forum – Threads Archive
encrypted procedure synchronizationHi,
I need to synchronize encrypted procedures in two databases. Is it possible at all, how it could be done, or may be which tool can perform such operation? Thanks.
I don’t think you can compare two sps with encryption enabled. Instead you can decrypt those SP.
There are methods availbe for decrypt those sps. Check this forum for those —————————————-
Contributing Editor, Writer & Forums Moderator
http://www.SQL-Server-Performance.Com Visit my Blog at
There are several links on this forum about decrypting the encrypted SP. This is one of them: http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=3271&SearchTerms=encrypt,stored,procedure You might have to tweek around to work in 2005 if it doesn’t work. Thanks,
There are some third party applications in the market… for one time you can dowload trial version and test it…
Thanks a lot for the information.