Post reply

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

  • September 1, 2017 at 4:05 am

    #348883

    Hello,

    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.

    Regards,
    S

  • September 1, 2017 at 4:43 am

    #1957795

    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 1 (of 1 total)

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