Oracle and SQL Server connectivity

[teqmem]

Hello,

Currently, we use Oracle as our enterprise database. I have a new requirement to develop a new application that must use MS SQL Server which must push and pull data from the Oracle database.

What is the best technical solution to have this communication between Oracle and SQL Server.

Thank you.

 

[aalmeida]

tegmem,

The esiest way to go about doing this would be to download the Oracle ODBC connector and install it at the SQL SERVER machine, then write your SQL server application to use the Oracle DB as a Linked Server.

AL Almeida
Senior DBA

http://www.saxotech.com/

"May all those that come behind us, find us faithfull"

 

[teqmem]

Is there an "easy" way to setup replication between an Oracle Database and a MS SQL Server.

In my planned configuration, the SQL Server (or something I develop) will need to pull qualified new database entries from the Oracle Database and push all its new entries to the SQL Server.

Thanks.