title: sql server encrypted column to be decrypted on another server
body: <p><a href="http://msdn.microsoft.com/en-us/library/ms179331.aspx" rel="nofollow">How to: Encrypt a Column of Data</a> shows how to encrypt a column of data in sql server and decrypt it <strong>in the same database instance</strong> the encryption part is exactly what I want however the decryption process would be different for me :</p>
  
  <p>I will create csv files from the tables with encrypted column and will import these files into another instance of sql server where the other server should be able to decrypt . </p>
  
  <p>A. how can I do the encryption on server A and do the decryption on server B ? (is it possible to send the other server the certificate file ?)</p>
  
  <p>B.the encryptor server is sql server 2008 can we do the decryption on sql server 2005 or develop .net module for doing the decryption ? </p>