RE: Oracle to Sql Server

[Adrian Roe]

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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 30 August 2001 17:07 To: [EMAIL PROTECTED] Subject: 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. ==============================================================================