Unanswered: Data migration - Sybase to Oracle - Use of an ETL tool
For Sybase to Oracle Data migration, can an ETL tool like SAS ETL be used? The data migration involves complex mapping from source to target tables. Is it a general practice to use an ETL tool for a data migration?
Be careful with the way dates are stored in each. Made sure day, month, year, time, etc. are mapped properly between RDBMSs.
I did my one thing with BCP out of Sybase and sqlldr in (with ctl files) to Oracle. If it's a one time thing, a tool may be the way to go, if you are going to do it more than once or twice, take the BCP/sqlldr plunge.
The oracle migration tool is completely free and will handle those pesky date fields etc automatically. It is provided by oracle so that people will convert to their database. It is a one way tool. It will not convert from oracle to any other product.
You do not need a parachute to skydive. You only need a parachute to skydive twice.