Download data from Oracle 8 to SQL Server 2005 | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Download data from Oracle 8 to SQL Server 2005

Hi, I have a table in Oracle 8 and a table in SQL Server 2005 with the same schema. I have created a SSIS to pull data (2 million rows) from the table in Oracle to the table in SQL Server 2005. However, i find that it takes very long time to do so. It takes about 2 hours. However, when i copy the data from the table to another table both in SQL 2005. It takes only few minutes…….. So what’s the problem? Thanks,
Linus
Try with a linked server
however, I think it will take more than sql server 2005 anyway —————————————-
Contributing Editor, Writer & Forums Moderator
http://www.SQL-Server-Performance.Com Visit my Blog at
http://dineshasanka.spaces.live.com/
Try exporting the data from oracle to a txt file then bulk insert txt into sql 2005…
MohammedU.
Microsoft SQL Server MVP
Moderator
SQL-Server-Performance.com All postings are provided “AS IS” with no warranties for accuracy.
Using SSIS is reliable method but in this case you have to consider how you are pulling the rows and also network contention and bandwidth from Oracle to SQL Server. we do get lot of complaints from our users in similar, every time it found out to be they are pulling too many rows from Oracle that are not required, so having such limited set of colums or required data will get you more performance. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
@http://www.askasqlguru.com/ This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
]]>