RE: Oracle to Sql Server

One of the easiest ways would be to spend money and get the Oracle Transparent Gateway for Microsoft SQL Server.  Its available on NT.   With the gateway you can run  queries and updates and such  from your Oracle Database to the SQL Server database as if they were on the same box.   
 
We used to use the Oracle Transparent
Gateway for DRDA to talk to our IBM DB2 mainframe database.   Worked Great.

  <FONT
  face=Tahoma>-----Original Message-----From: JOE TESTA   [mailto:JTESTA_at_longaberger.com]Sent: Thursday, August 30, 2001   12:07 PMTo: Multiple recipients of list ORACLE-LSubject:   Re: Oracle to Sql Server
  i'd think if u are abandoning oracle for M$, then check their website,   i'm sure they have a way to do it, just like oracle's website has a way to go   TO oracle FROM M$.
 

  joe
  >>> apps_sol_at_hotmail.com 08/30/01 12:06PM   >>>
  Hello Folks,
 

  I am looking for some cool script to move all the database objects   across from Oracle 8.1.7 to Latest Sql Server (ver ???) frequently.<FONT   face="Times New Roman">
 

  Is there any particular way we can do it to automate this ??<FONT   face="Times New Roman">
 

  BTW: I want to pledge $20 or even willing to pay yearly subscription and   it would be a good
  idea to Send out a Pledge form to everyone . to keep the greens   coming..
 

  Cheers
  RK
 
Received on Thu Aug 30 2001 - 11:59:48 CDT