This discussion is archived
4 Replies Latest reply: Jun 8, 2012 2:26 AM by 641985 RSS

SQL Devloper Migration from SQL SerProcedurs created as Functions in Oracle

641985 Newbie
Currently Being Moderated
Hi All,

This is the first time I am using SQL Deveoper to migrate SQL Server database to Oracle.

I have SQL Developer 3 and I did migration from SQL Sever 2008 to Oracle 10g using online migration.

Everything was done perfectly, but there are some extra tables created in Oracle which are not present in SQL Server database.
And also I observed lot of programs which are stored procedures in SQL Server are converted as functions in Oracle.

Does someone knows how to fix this problem.

Thanks

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points