Re: moving data from sybase/ms sql server to oracle

Hi

I would drop your triggers if you are going to insert data into the tables they are on. BUT you need to carfully understand what they do, ie is it ok to ignore what they do, do you need to create output or data later. I have had similar issues in the past and found that the only way to get data to load satisfactorly is to drop triggers for performance, but in general you mat need to do houskeeping after.

cheers
Pete Finnigan
www.pentest-limited.com

In article <8e84e57c.0108150255.483bf76d_at_posting.google.com>, simo <simax_at_mail.com> writes
>Hi,
>I am looking for assistance in the steps to follow to load data into
>oracle from sybase and ms sql server.
>I have bcp'ed all data out into .csv files and have created ctl files
>for each table.
>what are the steps to follow when using sql loader, for instance,
>if our application makes use of sequences, do I drop all the triggers
>and then load the data and then recreate the triggers? Would the
>sequences not need to be recreated?
>Any help would be greatly appreciated.

-- 
Pete Finnigan
IT Security Consultant
PenTest Limited

Office  01565 830 990
Fax     01565 830 889
Mobile  07974 087 885

pete.finnigan_at_pentest-limited.com

www.pentest-limited.com