1 Reply Latest reply on Jul 26, 2012 2:53 PM by Mkirtley-Oracle

    How to migrate all EXCEPT procedures from SQLSvr to Oracle?

      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)?