Migrate Sybase databases using SQL Developer
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.