Encryption Form SQL Server 2000

5 pts.
Tags:
Data transfer
Encryption
Microsoft SQL Server 2000
SQL Server migration
I want to transfer data from one database to another database both the databases are on SQL Server 2000. I want to transfer the data in encryption form. How do I do it? Regards, Sahil

Answer Wiki

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

You’ve got a few options, none of which are easy to setup.

  1. Export the data, then encrypt the file, then transfer the file, then decrypt the file, then import the file.
  2. Setup IPSec between the two SQL Servers and then transfer the data as normal.
  3. Setup a Secure FTP Server at the second SQL Server. Export the data, then use a SFTP server to transfer the file to the remove server, then import the file.

If you take option #1 you can use use openssl or PGP to encrypt the files.

If you take option #2 you can find some info about IPSec here.

If you take option #3 here is a site about setting up an SFTP server on Windows. This site also includes information on finding an SFTP client.

If I was setting this up I would probably go for Option #2, and if that didn’t meet my requirements Option #1.

Discuss This Question: 1  Reply

 
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