| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Oracle to Sql Server
Your
best bet is to look at SQL Servers Data Transformation
Services.
<FONT face=Arial color=#0000ff
size=2>
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.
<FONT face=Arial color=#0000ff
size=2>
<FONT face=Arial color=#0000ff
size=2>Ade
<SPAN
class=857250416-30082001><FONT face=Arial
color=#0000ff size=2>
<FONT face=Tahoma
size=2>-----Original Message-----From: apps_sol_at_hotmail.com
[mailto:apps_sol_at_hotmail.com]Sent: 30 August 2001 17:07To:
ORACLE-L_at_fatcity.comSubject: Oracle to Sql
Server
<FONT
size=2>
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 ??<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
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.
 |
 |