Can we migrate already encrypted data from SQL Server 2000 to MS SQL Server 2008

5 pts.
Tags:
SQL Server 2000
SQL Server 2000 encryption
SQL Server 2000 migration
SQL Server 2008
SQL Server 2008 encryption
SQL Server migration
I have encrypted data in MS SQL Server 2000. I want to migrate in MS SQL Server 2008. I have migrated successfully through the attach/dettach process but when I am trying to decrypt the data. is it giving different result or value. is the right process to migrate the encrypted data? Please suggest me ASAP. Thanks & Regards, Amit Khare

Answer Wiki

Thanks. We'll let you know when a new response is added.

You will probably want to migrate the process that was used on the SQL 2000 server to encrypt and decrypt the data as well until you can get the navive SQL 2008 encryption/decryption working correctly. You may need to decrypt your data and reencrypt your data if the SQL 2008 native encryption doesn’t support the same encryption that you used on the SQL 2000 server.

Can you provide more information about the methods used to encrypt the data?

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following