Re: Oracle Gateway to MSSQL

Information Builders Inc. may be able to help with the EDA/SQL product for Windows NT. This product can join data from both databases without moving the Oracle data into MS SQL Server. They also make a product to set up a scheduled extract and importing of data between databases.

Some things to consider before looking at products is the volume of data to be move between databases, the frequency of doing it, is the data for read only, etc.

If it is just a one time thing, or a once every couple of months, extracting the data from Oracle, ftp and BCP could be the best way to go.

On Fri, 25 Apr 1997 14:22:26 -0400, patrick.gaumond_at_fsa.ulaval.ca (GaumondP) wrote:

>Is there any gateway available to "talk" to Oracle from MS SQL server ? I
>need to attach some Oracle table to my SQL 6.5 server.
>
>
>In other words, I need to get information during the night from the Oracle
>server, put them in some local tables to have the ability to play locally
>on that "oracle" data. Once on my MSSQL server I will have the "oracle
>data" and some specific table with information not availble originally on
>the other server.
>
>Is there a gateway ?
>
>What's the best solution ?
>
>Will I need another costly software ?
>
>Any help or URL or solution will help me !
>
>Patrick Gaumond
>SQL Server newbie
Received on Tue Apr 29 1997 - 00:00:00 CDT