RATE THIS ANSWER
0
Click to Vote:
- 0
0
Last Answered:
May 26 2008 6:58 PM GMT
by Mrdenny
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.
Data transfer, SQL Server 2000, Encryption, SQL Server migration
I want to transfer data from one database to another database both the databases are on sqlserver 2000 i want to transfer the data in encrytion form how do i do it .....
