2 Replies Latest reply on Feb 12, 2019 6:54 PM by Mike Kutz

    Migration features of SQL Developer

    Jammin

      Hi All,

      I' d like to use the existing migration features in SQL Developer to migrate

      a MSSQL Server db structure (tables, views, procedures, etc...) into a Oracle

      db but I'm not interested to migrate the data.

      I need to recreate an exact copy of empty db in Oracle with the same structure

      with same table, views, procedures....

      I am newbie so exists a step-by-step tutorial to do this ?

       

      Thanks a lot to all....

       

      G.M.

        • 1. Re: Migration features of SQL Developer
          thatJeffSmith-Oracle

          migrations are setup in 2 primary steps, schema capture and data capture - what you want is pretty simple - just skip the data capture

           

          it has a wizard, you can walk it

           

          it's documented in the help, i've written 2 white papers as well

          • 2. Re: Migration features of SQL Developer
            Mike Kutz

            Jammin wrote:

             

            Hi All,

            I' d like to use the existing migration features in SQL Developer to migrate

            a MSSQL Server db structure (tables, views, procedures, etc...) into a Oracle

            db but I'm not interested to migrate the data.

            I need to recreate an exact copy of empty db in Oracle with the same structure

            with same table, views, procedures....

            I am newbie so exists a step-by-step tutorial to do this ?

             

            Thanks a lot to all....

             

            G.M.

            "Database Agnostic Code" is a myth.

             

            Oracle has a completely different transaction model than SQL Server.

            Those procedures will need to be reviewed to ensure that they "do things the Oracle way".

            Refactoring them into Packages almost guarantees a complete re-write of your application.

             

            My $0.02

             

            MK