Database encryption

  • Hi everyone,

    Is it possible to have database encryption in SQL 2005? I've been searching the net and everything that I've found so far talks about encrypting a table, but what if I have a database with a whole lot of tables/data?

  • In SQL Server 2005 it's actually at the individual column entry level on a row, not even at the column or table level, much less the database level. So to implement in an existing database would take a massive re-design. You're probably better off looking at 3rd party solutions in that case.

    K. Brian Kelley
    @kbriankelley

  • I agree with Brian. I used LiteSpeed and with this tool you can encrypt up to 256 bit. I guess you will be able to do the same with other third party tools.

  • Thanks for your input all.

Viewing 4 posts - 1 through 3 (of 3 total)

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