Competition: What’s your favorite Redgate tool? Enter now.

encrypted sprocs

jbrownjbrown Posts: 20
edited September 19, 2008 4:23AM in SQL Packager Previous Versions
Would it be possible (current version or future version) to allow for encryption of sprocs/functions/etc at time of build?

that way the developer can work from a non-encrypted database, but release an encrypted one.

or is there an easy way to do this I'm not thinking of? :)

Comments

  • Brian DonahueBrian Donahue Posts: 6,590 New member
    Hi,

    I believe you are looking for the "add WITH ENCRYPTION option to stored procedures, etc" item in SQL Packager's Schema options. That will insert "WITH ENCRYPTION" to anything that can be encrypted.
Sign In or Register to comment.