How to connect and transfer the data from Oracle to SQL Database

Hi !!

1) I would like to connect from oracle database to SQL database.
2) I would like to transfer the data from Oracle Tabels to SQL Databse Tabels.

Anybody can help me regarding this Data Transfer from Oracle to SQL Database
or vice versa.

Is there any tool available? or any script are available?.

Please send me the script or tool, if it is available.

Thanks,
RAJ

"Raj" <braj_2000@yahoo.com> wrote:
>
>Hi !!
>
>1) I would like to connect from oracle database to SQL database.
>2) I would like to transfer the data from Oracle Tabels to SQL Databse Tabels.
>
>Anybody can help me regarding this Data Transfer from Oracle to SQL Database
>or vice versa.
>
>Is there any tool available? or any script are available?.
>
>Please send me the script or tool, if it is available.
>
>Thanks,
>RAJ
>

Take a look at linked servers in SQL Books on line. This allows you to connect
to and query Oracle tables from within SQL Server. You can then use simple
INSERT INTO sqltable SELECT * FROM Oracletable type syntax. DTS also can
be used as it allows you to import from any data source that has an OLEDB
or ODBC provider into SQL Server.

"Raj" <braj_2000@yahoo.com> wrote:
>
>Hi !!
>
>1) I would like to connect from oracle database to SQL database.
>2) I would like to transfer the data from Oracle Tabels to SQL Databse Tabels.
>
>Anybody can help me regarding this Data Transfer from Oracle to SQL Database
>or vice versa.
>
>Is there any tool available? or any script are available?.
>
>Please send me the script or tool, if it is available.
>
>Thanks,
>RAJ
>


Hi Raj,
you can use gateway supply by oracle to connect an oracle database to
MS SQL server. You can create db_links which point to whatever tables
in your MS SQL Server database. So anyone in your server oracle can consult
datain MS SQL server database. Take a look in the documentation of oracle.
Regards.
Andriana.