July 19, 2007 at 3:29 pm
Greetings,
I am moving data between SQL Server and Oracle 10gR2 running on Linux. I would like to encrypt the data but have not been able to find specific documentation explaining how to do that. Is it possible and if so can someone point me at documentation. Thanks.
July 20, 2007 at 8:52 am
Insufficient data. As a principle, of course you can encrypt data. The hard part is correctly decrypting the encryption. WHAT will control the encrypt/decrypt process? That will answer whether (1) it's possible and (2) what options are feasible.
July 20, 2007 at 3:22 pm
Greetings, yes, I realize now my post was vague. Let me see if I can amplify. When using Oracle it is possible to install Oracle's Advanced Security Option piece. By then configuring the networking it is possible to encrypt traffic as it goes across the network from one Oracle database to another. It is a fairly simple configuration requireing only a few parameters be added to the sqlnet configuration files, sqlnet.ora specifically. Is there a similar piece available for SQL Server, a simple 'add-on' if you will which will easily enable encrypting data as it goes across the network. Thanks.
July 21, 2007 at 5:03 pm
If connecting to SQL Server, SQL Server can be set up to use an SSL certificate and create encrypted connections. Encryption can be forced on for all connectins using Server Network Utility. I know clients on the Windows side support this, but I don't know about the Linux side.
If you are connecting from SQL Server to Oracle, say via a linked server, SQL Server will use the Oracle client as installed on the SQL Server. Therefore, if there is some way to set that up to force encryption, you should be set.
Failing that, there might be a way to set up an IPSEC tunnel between the two servers.
K. Brian Kelley
@kbriankelley
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply