Asked • 06/24/19

Migrate / Copy Huge data from Oracle to SQL Server?

I have huge tables in oracle database, appx 1 crore+ (10 million+) rows and want to migrate / copy those table and data in sql server. Currently I am using Import functionality of SQL Server for this process. But it takes a day for this process and takes too much time. Is there any better way? Any good outcome or step (SSIS, Any other functional step) to follow for this process?

1 Expert Answer


Brijesh S. answered • 12/31/20

5 (3)

SQL DB Architect; Python, SQL, Oracle-Certified Associates

Still looking for help? Get the right answer, fast.

Ask a question for free

Get a free answer to a quick problem.
Most questions answered within 4 hours.


Find an Online Tutor Now

Choose an expert and meet online. No packages or subscriptions, pay only for the time you need.