Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2005
    Posts
    19

    Unanswered: DTS Vs Link server ???

    Hi,

    I am using Oracle 10g and SQL Server 2005.

    Monthly I have to transfer around 100 million records from Oracle table to SQL server table.

    I dont have ETL tools. I have only two option DTS and Link server.

    Which is the best one to transfer data.

    Thanks,
    Venkataraman L

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    If you use the Linked Server, do you need to move the data at all? Using four part names seems like the best option to me if that will address your needs.

    -PatP
    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

Posting Permissions

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