SQL Server Migration

I want to migrate from a SQL server 2000 database to Oracle 10g. What is the asiest way to do it, as time is a constraint. If I use DTS then does it migrate the stored procs as well, or do I have to change them manually?

Thanks in advance.

http://www.freedownloadscenter.com/P...tion_Tool.html

DTS does not migrate stored procedures to Oracle. You have to change them manually or use some commerically avaiable tools.

I've tried SwisSQL. This tool also converts stored procs and functions:

http://www.swissql.com/products/sqls...to-oracle.html

regards,

Helmut Leitner

Thanks all. I have downloaded SwisSql and trying it now.