Exchanging database info to a hosting party in a safe way (40 Views)
Reply
Regular Advisor
Klaas D. Eenkhoorn
Posts: 108
Registered: ‎11-04-2002
Message 1 of 2 (40 Views)

Exchanging database info to a hosting party in a safe way

All,

More and more we get the question if we can exchange data from our internal Oracle HPUX database to a remote hosted MSSQL Windows database. Currently we copy a CSV file with SCP to the remote site where an import process is running. My question is are the 'better' and securrer solutions possible to keep a remote database up-to-date ?

Especially suggestions about way's of secure transport are welcome!

Info: It does not have to be a dump or somthing, a CSV file with mutations is sufficient.

Kl@@s
Occasional Advisor
IMGERALD
Posts: 5
Registered: ‎09-05-2008
Message 2 of 2 (40 Views)

Re: Exchanging database info to a hosting party in a safe way

Check out Heterogeneous Services.
It is by far the simplest. Good luck.

http://download-west.oracle.com/docs/cd/B14117_01/server.101/b10764/admin.htm#1007206
The opinions expressed above are the personal opinions of the authors, not of HP. By using this site, you accept the Terms of Use and Rules of Participation.