Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
timmy
Master Smack Fu Yak Hacker
1242 Posts |
 Posted - 2009-01-14 : 19:31:17
|
| Hey all, I've got a requirement to copy across a large amount of data from an Oracle database onto my SQL Server 2000 box. The total amount of data is about 30GB across about 11 tables. Currently I have a DTS package with some simple Data Pump tasks to pull the data in using the MS Oracle OLEDB driver (which I've read is the fastest). The transformations are very simple - all Copy Column (i.e. no ActiveX scripting). It is taking a long time - between 12 and 16 hours. Is there a faster way of copying it across?Cheers,Tim |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-01-14 : 20:16:22
|
| Other way you can dump Oracle tables to text files and then Bulk insert from it to SQL Server. |
 |
|
|
|
|
|
Fastest way of importing from Oracle