Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
Next revision Both sides next revision
faq:migration-toolkit:schedule-migration-process [2019/09/20 12:24]
darya.prikhodkina
faq:migration-toolkit:schedule-migration-process [2019/09/20 12:27]
darya.prikhodkina
Line 1: Line 1:
 ====== How to Schedule Migration Process ====== ====== How to Schedule Migration Process ======
  
-After you have ran the conversion with the sql file specification,​ as it is described in the [[sqlways:​users-guide/​wizard/​specify-db-objects-or-query#​use_query|"​Specify Database Objects or Query Page"​]]article,​ in the export directory you will find the //​sqlways_exp_imp.bat//​ file, which can be used for scheduling the migration process. You can simply use this batch file or any of the commands from this file individually.+After you have ran the conversion with the sql file specification,​ as it is described in the [[sqlways:​users-guide/​wizard/​specify-db-objects-or-query#​use_query|"​Specify Database Objects or Query Page"​]] article, in the export directory you will find the //​sqlways_exp_imp.bat//​ file, which can be used for scheduling the migration process. You can simply use this batch file or any of the commands from this file individually.
  
 This file contains the following commands: This file contains the following commands:
Line 7: Line 7:
   cd "​S:​\Sqlways\Bin\Release"​   cd "​S:​\Sqlways\Bin\Release"​
  
-Goes to the folder where the sqlways.exe resides.+Moves to the folder where the sqlways.exe resides.
  
   SQLWays.exe ​ /​D=DB2_LEONOV_SAMPLE /U=db2admin /​P=Ispirer_1999 /​SF=S:​\support\Ispirer\department.sql /SROW=1 /​TARGET=MySQL /​TH=localhost /TD=itest /TU=root /TP=root /MIGS=Clean /​IMPS=Windows /​DIR=S:​\support\test\Export7 /R=1000 /​INI=sqlways_wzd.ini /​PRJF=sqlways.xml /NSTOP /​GCMD=sqlways_all.bat /RC /​LOG=sqlways.log /​RPT=sqlways_report.html /TRACE   SQLWays.exe ​ /​D=DB2_LEONOV_SAMPLE /U=db2admin /​P=Ispirer_1999 /​SF=S:​\support\Ispirer\department.sql /SROW=1 /​TARGET=MySQL /​TH=localhost /TD=itest /TU=root /TP=root /MIGS=Clean /​IMPS=Windows /​DIR=S:​\support\test\Export7 /R=1000 /​INI=sqlways_wzd.ini /​PRJF=sqlways.xml /NSTOP /​GCMD=sqlways_all.bat /RC /​LOG=sqlways.log /​RPT=sqlways_report.html /TRACE
  
-Runs the sqlways.exe command line tool with all the options specified during the Wizard run. As you can see there is the /SF option that lets you specify the SELECT statement for the conversion. For more information about the options please refer to the article [[sqlways/​command-line|"​SQLWays Command Line"​]].+Runs the sqlways.exe command line tool with all the options specified during the SQLWays ​Wizard run. As you can see there is the /SF option that lets you specify the SELECT statement for the conversion. For more information about the options please refer to this article[[sqlways/​command-line|"​SQLWays Command Line"​]].
  
   "​S:​\support\test\Export\sqlways_all.bat"​   "​S:​\support\test\Export\sqlways_all.bat"​
  
-Runs the import into the target database.+Runs import into the target database.
  
 \\ \\