3 Replies Latest reply: Mar 22, 2013 6:19 AM by Dermot Oneill-Oracle RSS

    Sql developer migration time

    11g.DBA
      Hi,

      One month back,I did migration of mysql to oracle using sql developer.It took around 2-3 hours to finish.But when I am again migrating the same database,the estimated time is around 150 hours.There were no big changes in the database in one month.Its taking a very long time to capture constraints.

      Scenario is as follows
      test(MySQL) --> test(Oracle schema) took 2-3 hours
      test1(MySQL) --> hms(Oracle schema) ongoing from last 6 hours and expected finish time around 150 hours
      Please advise

      Thanx
        • 1. Re: Sql developer migration time
          Dermot Oneill-Oracle
          Hi,

          What version of SQL Developer are you using. Is this different from the previous migration.
          Are you performing offline or online capture?
          Is SQL Developer installed on the same machine as the Oracle migration repository ?

          Ill try and replicate the issue here, any details appreciated about the MySQL database.

          Regards,
          Dermot.
          SQL Developer Team.
          • 2. Re: Sql developer migration time
            11g.DBA
            I am using Sql Developer 3.2.It is same as previous migration.
            Performing online capture.
            SQl developer installed on a different machine than oracle and MySQL database.

            xx.xxx.xx.28 --> MySQL
            xx.xxx.xx.30 --> Oracle
            xx.xxx.xx.10 --> SQL developer

            Thanx
            • 3. Re: Sql developer migration time
              Dermot Oneill-Oracle
              Hi,

              I am unable to replicate the issues here.

              I created a 500 table MySQL database with constraints on each table and it captured online quickly.
              My only guess is there is some additional load on one of your machines which maybe slowing down the process?
              As an alternative path, you could attempt the offline capture of your database.
              * Tools > Migration > Create Database Capture Script
              * Choose MySQL 5 windows or whatever suits
              * Run these scripts on your MySQL machine (with MySQL client) to dump out the databases metadata
              * Move all the files to your SQL Developer machine
              * Capture Offline the mysql5.ocp

              Sorry I couldn't have been more help
              Regards,
              Dermot.

              SQL Developer Team.