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

Thread: Data Transfer between Oracle and SQL Server

  1. #1
    Join Date
    Jun 2002


    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
    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,

    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