SQL server 2005 to oracle + over internet

[davida37]

hi,

It is possible to connect a SQL server 2005 db to an oracle db over the internet and specifically over HTTPS? i.e. is it possible to set up a linked server (or equivalent) between the 2 dbs (not on the same network) to communicate securely over the internet?

The remote oracle db would only be pulling data from the sql server database and not vice versa.

We have a public facing machine which has an SSL cert, so HTTPs would be the desired option if possible.

thanks
da

 

[mrdenny]

Yes you can setup to machines to talk over the Internet. You will be much better off setting up a VPN connection from one site to another and routing the network traffic over that VPN session. This way you don't have to worry about getting the encryption working on the SQL Server and ORacle server and you don't have to add the overhead to the servers of handeling the encryption and decryption.

Denny
MVP
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog