Re: Pushing data from oracle into sql server?

joeblow <dadude_at_casselout.dk> wrote in message news:<pan.2004.06.22.23.03.08.809663_at_casselout.dk>...
> Hey folks,
>
> We have our own isolated network that we keep critical and confidential
> and important and all those words machines, instrumentation and data on.
> On this network is an oracle 7.3 database running on solaris 2.5.1. This
> is part of the primary application that is running on this 'inside'
> network.
>
> There is now a <justifiable> business need to make the data on this
> database available to others on the enterprise, but we must maintain the
> sanctity and reliability of the 'inside' network and data and application.
>
> Before today, part of protecting this inside network was a policy of
> 'no connectivity outside, nohow, nowhere'. Obviously can't do this now.
> So we've modified our policy to 'connections to outside systems shall only
> be initiated from our side', and then we can do the pix firewall and
> 'fixup protocol' thing.
>
> But....
>
> The MIS folks want to use an SQL Server for the enterprise-available
> database. They insist that the only way to move data from an
> oracle database to an SQLServer database is that their SQLServer must
> initiate a connection to our oracle and 'pull' data.
>
> this is the method that my googling keeps bringing up as well.
>
> I'm not seeing anywhere that tells me how to set up where oracle goes out
> and connects to their sqlserver and 'pushes' our data into their
> sql server database.
>
> So, in a nutshell:
>
> Can Oracle 7.3 initiate a connection thru a pix (fixup protocol
> 1521) to an sqlserver database and transfer data -into- the sqlserver? If
> so, can someone provide pointers or urls where.
>
> Many thanks in advance

There is a serious split between the problem you are trying to solve and the version you own.

Let me guess they want to use ODBC.

Good luck. Received on Wed Jun 23 2004 - 23:06:07 CEST