February 3, 2014 at 12:14 pm
Hello,
I am importing data from SQL server into Oracle Database and it's taking too much time. I tried both Native OLD DB and Oracle DB but non of them really help me to fast the data transfer.
Interestingly when I transfer data from Oracle into SQL it is running like a supersonic plan and super fast but not the other side.
Any suggestion or trick to make it fast?
Thanks,
February 3, 2014 at 3:00 pm
The problem is probably that you're not doing a bulk insert into Oracle (while you are doing a bulk insert into SQL Server, hence the performance difference).
You can try the Attunity adaptors, they are free.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
February 3, 2014 at 3:51 pm
Thanks for the reply. Where can I find the Adapter for Oracle?
Thanks
Yash
February 3, 2014 at 11:51 pm
yashuvp (2/3/2014)
Thanks for the reply. Where can I find the Adapter for Oracle?Thanks
Yash
Did you not see the link I posted?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
February 4, 2014 at 7:30 am
Sorry, I just overlooked the link. I was under that impression that it's your signature!
Thanks for quick reply.
Thanks,
Yash
March 3, 2014 at 3:15 pm
yashuvp (2/3/2014)
Hello,I am importing data from SQL server into Oracle Database and it's taking too much time. I tried both Native OLD DB and Oracle DB but non of them really help me to fast the data transfer.
Interestingly when I transfer data from Oracle into SQL it is running like a supersonic plan and super fast but not the other side.
Any suggestion or trick to make it fast?
Thanks,
Did you try fast load option ?
--
SQLBuddy
March 4, 2014 at 12:01 am
sqlbuddy123 (3/3/2014)
yashuvp (2/3/2014)
Hello,I am importing data from SQL server into Oracle Database and it's taking too much time. I tried both Native OLD DB and Oracle DB but non of them really help me to fast the data transfer.
Interestingly when I transfer data from Oracle into SQL it is running like a supersonic plan and super fast but not the other side.
Any suggestion or trick to make it fast?
Thanks,
Did you try fast load option ?
--
SQLBuddy
The fast load option is not available when Oracle is the destination.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 4, 2014 at 8:59 am
Thought fast load was available for Oracle destination too. May be I missed it ..
--
SQLBuddy
March 4, 2014 at 12:48 pm
sqlbuddy123 (3/4/2014)
Thought fast load was available for Oracle destination too. May be I missed it ..--
SQLBuddy
It depends on the OLE DB provider I think.
It's possible the Microsoft OLE DB provider for Oracle (which is deprecated if I remember correctly) has a fast load option, but the Oracle OLE DB provider doesn't.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 4, 2014 at 1:24 pm
It depends on the OLE DB provider I think.
It's possible the Microsoft OLE DB provider for Oracle (which is deprecated if I remember correctly) has a fast load option, but the Oracle OLE DB provider doesn't.
Yeah that's what I remembered . May be Yashuvp can check that .
Here is the link ..
http://msdn.microsoft.com/en-us/library/ms141237(v=sql.100).aspx
--
SQLBuddy
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply