Post reply

Deploying "encrypted" stored procs

  • January 16, 2006 at 1:37 pm

    #152703

    Hello,

    I'm beginning to deploy some stored procedure updates to many branch offices, I could use a standard script to alter existing sps or create the new ones, but I must be sure the sps scripts are not being changed before running the updates.

    Is there anyway to deploy "encrypted" stored procs ???

    TIA,

    Felix

  • January 17, 2006 at 5:53 am

    #615107

    That depends on what you're using, I assume you script the DB objects in SQL and the encrypted ones don't get transferred because they can't be scripted?

    You can either use a 3rd party tool to decrypt them prior to the move, or use another tool like SQL Compare that will decrypt for you prior to the move and then re-encrypt at the other end.

    Mike

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply