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!

Migrate Sybase databases using SQL Developer

bp419196isMar 4 2010
Hi,

I've been testing the Migrating with the SQL Developer, and ran into some odd issues.

I've been trying to migrate some of our Sybase 12.5 databases to Oracle.

I'm using 2.1.1.64 build MAIN-64.39.

The steps I'm using.

- Create the Sybase connection. This works fine and I can browse the tables, along with the data.
- Right click the Sybase connection and choose Capture Sybase. This seems to work
- Right click the Captured model and click convert to Oracle. This also works.
- Right click on the Converted model and choose generate. This works.
- Run the generate scripts as a dba user. Works.
- Create the connection in SQL Developer for the user created in the previous step.
- Move data using the connection created in step 1 plus the connection created in the previous steps.

Most of the tables and objects move fine. A couple of the tables on the latest one I tried, a third of the rows migrated, but the status says finished in the "Moving Data to Oracle" window, with 0 errors.

If I look through the migration logs, I can't see any errors ... a few warnings of things I need to fix in the stored procedures.

Any ideas of where I might look? The process looks like it should be easy, but isn't very flexible at the moment.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 1 2010
Added on Mar 4 2010
0 comments
704 views