Encrypted procedures comparison

• kasper-383322

  Old Hand

  Points: 349

  More actions

  December 6, 2006 at 5:53 am

  #170641

  Hi,

  I have to synchronize encrypted procedures in two databases. Is it possible at all? How could be CREATE script generated for such procedure, or may be which tool can perform such operation(scripting/comparison for encrypted procedures)?

   

  Thanks.

• MohammedU

  SSCoach

  Points: 19644

  More actions

  December 6, 2006 at 10:35 am

  #676330

  I don't thin there any way to compare without decrypting...

  But you can check some third party tools which compares object schema/data out in the market.

  ex: http://www.x-sql.com/

   

   

  MohammedU
  Microsoft SQL Server MVP

• MohammedU

  SSCoach

  Points: 19644

  More actions

  December 6, 2006 at 3:45 pm

  #676452

  If you are interested..

  http://www.developersdex.com/sql/message.asp?p=1925&r=5243447

   

  MohammedU
  Microsoft SQL Server MVP