From Adrian.Roe@telewest.co.uk Thu, 30 Aug 2001 09:51:35 -0700 From: "Adrian Roe" Date: Thu, 30 Aug 2001 09:51:35 -0700 Subject: RE: Oracle to Sql Server Message-ID: MIME-Version: 1.0 Content-Type: text/plain Your best bet is to look at SQL Servers Data Transformation Services.   So long as you have Net8 plus an Oracle OLEDB provider installed on the SQL2000 box you should be able to pull all of the Oracle tables across.   Ade   -----Original Message-----From: apps_sol@hotmail.com [mailto:apps_sol@hotmail.com]Sent: 30 August 2001 17:07To: ORACLE-L@fatcity.comSubject: Oracle to Sql Server 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   ------------------------------------------------------------------------------ Live Life in Broadband www.telewest.co.uk The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Statements and opinions expressed in this e-mail may not represent those of the company. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender immediately and delete the material from any computer. ==============================================================================