Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Migration from Sybase to Oracle

3180Mar 7 2010 — edited Mar 16 2010
Hi 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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 13 2010
Added on Mar 7 2010
5 comments
1,652 views