Migration from Sybase to Oracle
3180Mar 7 2010 — edited Mar 16 2010Hi guys,
We are investigating using SQL Developer for the data migration from Sybase to Oracle database. Having looked at the tutorial here http://www.oracle.com/technology/obe/hol08/sqldev_migration/sybase/migrate_sybase_otn.htm#t, I have a few questions :
1. We are only interested in the data migration and not any source code from sysbase, when creating the database capture scripts is there a option to extract the table definitions only ?
2. Subsequent to the initial database capture scripts, if there are any table structure changes in sybase (like adding a new column to a table), do the scripts need to be run or can the DDL's be performed directly on the oracle converted model ? If yes, how does this effect the data migration process, will it know about the new column ?
3. Can individual tables be migrated or it has to be the entire schema ?
4. How does the tool perform when multiple migration cycles are performed ? I am sure we won't get it right the very first time !
It would be great if people who have used/are using this tool for data migrations to come out and share their experience ?
Thanks in advance