How to Schedule Migration Process

After you have ran the conversion with the sql file specification, as it is described in the "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:

cd "S:\Sqlways\Bin\Release"

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

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".


Runs import into the target database.

More about Ispirer Systems