Post reply

Database encryption

  • August 7, 2008 at 9:36 am

    #190794

    i've been asked to encrypt and entire 30gb SQL 2005 database for transfer to another site. my understanding is that the encryption technology inside SQL05 only allows you to encrypt data coming to/going from the database; i can't encrypt an entire database at once... or can i?

    basically, i want to take a copy of the database, encrypt the entire thing, send it off, then have them decrypt it. is that possible using native sql 2005 tools?

  • August 7, 2008 at 10:01 am

    #854567

    SQL 2005's encryption allows you to encrypt specific columns in tables. It does not allow you to encrypt the entire database. (SQL 2008 has that)

    Perhaps look and see if you can find a compressions tool (like winzip) with strong encryption.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • August 7, 2008 at 10:05 am

    #854574

    perfect, that's what i needed to know. i didn't think it was, but it's always nice to get a second opinion.

    thanks...

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

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