This discussion is archived
1 Reply Latest reply: Jul 26, 2012 7:53 AM by mkirtley-Oracle RSS

How to migrate all EXCEPT procedures from SQLSvr to Oracle?

user12240205 Explorer
Currently Being Moderated
We are trying to migrate a SQL Server 2008 DB to Oracle 11g.

We are using SQL Developer (3.1.07).

We use the Migration Wizard.

It works (i.e. on-line method), but we have a issue like this:

We need to migrate only Tables, Views and Sequences. We DON'T need to migrate the SQL Server procedures and functions. There is no option to select/deselect the type of objects to migrate.

How can we selectively migrate only the objects or object types we want and not migrate the rest (like procedures and functions)?

Legend

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