Skip to Main Content

Oracle Database Discussions

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!

SQL Server 2005 - stored procedures not getting migrated

40384Mar 15 2007 — edited May 30 2007
Hi, I am trying to migrate a SQL Server 2005 database to Oracle 10g. I have installed SQL Developer with migration workbench plug-in and configured SQL developer to connect to SQL Server and Oracle. I am able to migrate tables, indexes, triggers, etc. But it is not migrating any stored procedures.

Here is my setup
SQL Developer 1.1.2.25
Oracle Migration Workbench plug-in 10.2.0.0612
SQL Server 2005
Oracle 10g

My test SQL Server database has only one table and one stored procedure.

My process
- Connect to both SQL Server and Oracle
- In the Connection window, select capture (schema or SQL Server. Both produce the same result)
- All the objects (including stored procedures) show up in the Captured Objects window
- Select convert to Oracle model
- Accept the default options
- All objects (including stored procedures) show up in the Converted Objects window
- Select generate
- It generates scripts for tables, but not for stored procedures.

I tried this will a much larger database with 100s of objects, most objects are converted. But none of the stored procedures are converted.

Any help or suggestion would be great.

Thanks,
Joseph
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 27 2007
Added on Mar 15 2007
3 comments
1,553 views