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
faq:migration-toolkit:schedule-migration-process [2019/06/12 00:49]
127.0.0.1 external edit
faq:migration-toolkit:schedule-migration-process [2022/05/24 15:23]
vladimir.gribok removed
Line 1: Line 1:
 ====== How to Schedule Migration Process ====== ====== How to Schedule Migration Process ======
  
-After you ran the conversion with the sql file specification,​ as in the [[sqlways:​users-guide/​wizard/​specify-db-objects-or-query#​use_query|"​Specify Database Objects or Query Page"​]]article ​is described, you will find the //​sqlways_exp_imp.bat//​ file in the export directory, which you can use for scheduling the migration process. You can use simply the batch file or each 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.
  
 \\ \\