DTS performace tip!!

[varadarajanvasu]

Hi,

When we migrate the data from sqlserver to oracle
using DTS export/import , we have been facing problems
in performance. It takes 24 hrs for
migrating data of 12 lakhs.

Will be very helpful if you can provide performance
tips in sql server export for huge volume of records
movement between databases.

Regards

varada

varadarajan.vasu@citigroup.com

 

[MDXer]

Fastest way to get Data out of SQL is BCP to a flat file either csv or fixed width. Not being an oracle person I'm not sure how you would then import this into oracle.

Shoot Me! Shoot Me NOW!!!
- Daffy Duck