3 Replies Latest reply: Apr 12, 2014 5:44 AM by Voudas75 RSS

    Sql Developer Mysql to Oracle Migration Offline script execution location

    Voudas75

      Hello ,

       

      During Sql Developer's Migration Procedure , it gives you the option for offline Migration .

       

      Using this option under datamove directory several scripts are created .

      Among them there are script using the mysqldump command , with the -T ( --tab ) option .

      e.g

       

      mysqldump -h %servername% -u %username% -p%password%  -T data --fields-terminated-by="<EOFD>" --fields-escaped-by="" --lines-terminated-by="<EORD>" "schema" "new_table"

       

      From mysql's documentation is clear that command with -T should run only on the server where mysql runs .

       

      Does this mean that offline scripts concerning mysql , should be transferred and executed on mysql server ?