Thanks ganesh ...
I have transparent gateway and replication is set between sqlserver
And oracle but it's taking long time to move the data. To move
thousand records it takes 15 minutes . Oracle server is in remote
place .
I am going to try loader now ....

Regards,
shibu

-----Original Message-----
From: Ganesh Raja [mailto:[Email Address Removed]
Sent: Monday, July 22, 2002 11:12 AM
To: 'M B Shibu '
Subject: RE: moving data from sqlserver to oracle

Transperent Gateways are one way to do this ...
ANother easier and simpler and faster way is to use sql loader... Dump
the
data into a flat file and load it with sqlloader.

HTH


Best Regards,
Ganesh R
Tel : +971 (4) 397 3337 Ext 420
Fax : +971 (4) 397 6262
HP : +971 (50) 745 6019
============================================
Live to learn... forget... and learn again.
============================================
-----Original Message-----
From: M B Shibu [mailto:basher.[Email Address Removed]
Sent: Monday, July 22, 2002 9:04 AM
To: LazyDBA.com Discussion
Subject: moving data from sqlserver to oracle


Hi friends .............

Which is the fastest method to move data from sqlserver to Oracle?
I have a table in sqlserver which has 5 million records
I want to move that table to oracle. I am looking for the fastest
method .

Can anyone help me in doing this???


Thanks

Shibu

Oracle LazyDBA home page