HELP - Ideas for Oracle / MS Sql Interface.

From: Johne_uk <edgarj_at_tiscali.co.uk>
Date: 3 Jul 2006 07:45:41 -0700
Message-ID: <1151937941.453144.280200@a14g2000cwb.googlegroups.com>

Hi,

I've been asked to look at developing a new interface between Oracle and MS Sql Server. The setup is as follows.

Oracle 9i installation on Solaris 9. Various standalone tables are populated with data via an application (periodically).

The data in these tables needs to be copied to identical tables on a MS Sql Server DB running on Windows and accessed via a VPN. The data will only ever flow from Oracle to SQL.

The tables are identical on both sides (compatible filetypes) and the update process will be carried out every 30 minutes (realtime not required).

I need to develop an interface that will copy the data from Oracle to MS Sql. The interface will be located on the Oracle unix server. Ideally, I would want to use shell scripts etc. to write the interface.

I'm looking at initial ideas of the best way to to achieve this i.e. an effective mechanism.

Thanks in advance
John Received on Mon Jul 03 2006 - 09:45:41 CDT