SQL Server 2005 - stored procedures not getting migrated
40384Mar 15 2007 — edited May 30 2007Hi, 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