How to get huge data from oracle to sql server most efficiently?

  • Sachin Vaidya

    Ten Centuries

    Points: 1273


    Please let me know what could be the most efficient way to copy data from an oracle table (180 million rows) to a SQL server table most efficiently.



    SSC Guru

    Points: 112514

    A number of ways spring to mind, but as for the most efficient that depends on your hardware, network and setup.

    Solutions would be replication (Oracle can be a publisher), standard SSIS Oracle Source SQL Destination data flow tasks, BCP Out from Oracle, BCP In to SQL or SSIS In to SQL, linked servers.

    Again the list goes on so it would be a case of pick a couple of ways and see what works best for your environment.

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply