Hello Stephane,
Thanks for the reply.. yes the volume is not too big.. but even then it will
be substantial amount of data transferred only from SQL Server to Oracle.
I was not willing to write an application, but seems from the reply there is
no other way.. at present.. (I tried from Oracle to A
Nikunj,
You can try something I did a long time ago, in Oracle 7.3; but it's also
applicable now.
Create an ODBC datasource on the machine where the SQL Server resides to
pint to the Oracle database. For the initial load, I suppose you can create
a table in SQL Server as "select * from table_in_o
2 Options:
1. Use MS Data Transport Service (DTS) and schedule transfer task
2. Write a Java program that will connect to both databases and transfer the
data.
Raman.
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Saturday, March 15, 2003 12:48
Nikunj Gupta wrote:
>
> Hello,
>
> SQL Server in on Windows 2000 Box.
> Oracle 8.1.7 is on Unix.
>
> Is there any process by which data can be transferred from SQL SERVER to
> ORACLE directly.. something like views / snapshots. (Requirement is almost
> realtime data from SQL Server to Oracle)
>