RE: Oracle to Sql Server

[Kevin Lange]

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. -----Original Message----- From: JOE TESTA [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 30, 2001 12:07 PM To: Multiple recipients of list ORACLE-L Subject: 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 >>> [EMAIL PROTECTED] 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.   Is there any particular way we can do it to automate this ??   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