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


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 3 of 3

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

  1. #1
    Raj Guest

    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


  2. #2
    Doug Guest

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


    "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.


  3. #3
    andriana Guest

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


    "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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center