Extracting data from an encrypted SQL database


  • Hi

    Apologies if this is obvious but I am new to SQL database Encrytion.

    I have a SQL Server 2008 r2 Standard edition  Database using column level encryption hosted on a remote web server. Server  hosted by another company.

    I now have a requirement to query that data on a daily basis and import the information into a database hosted locally.

    How can I achieve this. Any advise appreciated.

    My initial thoughts were to backup the database remotely then FTP the backup file  into the company and restore it locally for querying.

    Obviously I would have to remove the Service level encryption and just rely on the database Masterkey as the top level key.

    and then open up the now local database with the database master key.


    However this seems rather inelegant and their must be a better way of handling this.

    So any thoughts or suggestions would be greatly appreciated.

    Thursday, April 25, 2013 11:47 AM