Data Transfer between Oracle and SQL Server
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Data Transfer between Oracle and SQL Server

  1. #1
    Join Date
    Jun 2002
    Posts
    2

    Question

    The data transfer from SQL Server to Oracle is implemented through link server concept of SQL Sever.
    But,How the data transfer from Oracle to SQL Server will be made possible ?. Is there any concept like Linked Server ? so that we can declare the SQL Server as the Linked Server to Oracle.

  2. #2
    Join Date
    Jun 2002
    Posts
    7
    Hi,
    In oracle database links are avilable but the use is to connect remote oracle database. but in oracle you can write the table contents to a file and in sqlserver using BULKINSERT(or import wizard) you can copy the data.
    And also using import/export wizard in SQLSERVER you can copy or move data from/to any database using odbc drivers.

    with regards,
    v.sathishkumar

    Your efforts may fail. But don't fail to make any efforts

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width