February 3, 2012 at 3:22 am
Hi all,
I have a requirement to push hugh data(500K records at one go) from SQL to ORACLE (viceversa), so i just want to know what all the best ways out there.
Performance(fast load) is the first priority.
To add above i know we can do have Oracle Provider for OLEDB, Microsoft OLE DB provider for Oracle. I tested with them its really slow. Please share me if you came across any alternatives.
Thanks in advance.
Thanks,
Sunil.
February 3, 2012 at 3:42 am
The OLE DB adaptors shouldn't be that slow.
Did they read slow or write slow? You did use the fast load option in the OLE DB Destination, I hope.
Check out the Attunity connectors, they are a bit faster.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
February 3, 2012 at 7:21 am
Koen Verbeeck (2/3/2012)
The OLE DB adaptors shouldn't be that slow.Did they read slow or write slow? You did use the fast load option in the OLE DB Destination, I hope.
Check out the Attunity connectors, they are a bit faster.
+10k on Koen's suggestion to look at Attunity's connectors for Oracle. Writing to Oracle with their connectors will be about 100 times faster, because for some reason (and I think it has to do with logging) the OLEDB providers will only write a single record at a time (to Oracle specifically).
February 3, 2012 at 9:46 am
Koen / Martin
Appreciated for your efforts in replying my post.
I have used OLEDB, i want to read from SQL then write into Oracle. So read was good but writing into Oracle was really slow.
I double checked but couldnt find the Fast load option for OLEDB oracle destination...
As per your suggestion will try with Attunity's connectors for Oracle and update you.
Thanks,
Sunil.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply