Table data transfer from SQL Server to Oracle is very slow  
Author Message
bikora





PostPosted: Tue Apr 04 01:24:27 CDT 2006 Top

SQL Server Developer >> Table data transfer from SQL Server to Oracle is very slow

Hi,



I need to transfer tables with massive amount of records from SQL Server to
Oracle database. DTC related techniques are very slow and I don't need any
transaction.



What would be the fastest way to transfer data from SQL Server to Oracle
every night?



Any help would be appreciated,

Max

SQL Server80  
 
 
Uri





PostPosted: Tue Apr 04 01:24:27 CDT 2006 Top

SQL Server Developer >> Table data transfer from SQL Server to Oracle is very slow Hi
What vesrion are you using?
In SQL Server 2005 you may try to use SSIS to move the data.



> Hi,
>
>
>
> I need to transfer tables with massive amount of records from SQL Server
> to Oracle database. DTC related techniques are very slow and I don't need
> any transaction.
>
>
>
> What would be the fastest way to transfer data from SQL Server to Oracle
> every night?
>
>
>
> Any help would be appreciated,
>
> Max
>
>


 
 
Vinod





PostPosted: Tue Apr 04 02:55:28 CDT 2006 Top

SQL Server Developer >> Table data transfer from SQL Server to Oracle is very slow DTS is a very good option and hope you have tried that.

--
HTH,
Vinod Kumar
MCSE, DBA, MCAD, MCSD
http://www.extremeexperts.com



> Hi,
>
>
>
> I need to transfer tables with massive amount of records from SQL Server
> to Oracle database. DTC related techniques are very slow and I don't need
> any transaction.
>
>
>
> What would be the fastest way to transfer data from SQL Server to Oracle
> every night?
>
>
>
> Any help would be appreciated,
>
> Max
>
>


 
 
Maxwell2006





PostPosted: Tue Apr 04 17:43:55 CDT 2006 Top

SQL Server Developer >> Table data transfer from SQL Server to Oracle is very slow
We have tables with average 400,000,000 records.
After trying DTS, now I underestand that DTS is a useless toy in large data
situation.

Are you sure SSIS has some performance improvements comparing to DTS ?

It take 20 min to extract a table into a text file by using BCP. I am
looking for a modern tool with similar performance.






> Hi
> What vesrion are you using?
> In SQL Server 2005 you may try to use SSIS to move the data.
>


>> Hi,
>>
>>
>>
>> I need to transfer tables with massive amount of records from SQL Server
>> to Oracle database. DTC related techniques are very slow and I don't need
>> any transaction.
>>
>>
>>
>> What would be the fastest way to transfer data from SQL Server to Oracle
>> every night?
>>
>>
>>
>> Any help would be appreciated,
>>
>> Max
>>
>>
>
>