Ispirer Ispirer
Ispirer
 


Ispirer Home Page Ispirer SQLWays Migration Product Page Request SQLWays

How to Schedule Migration Process

After you ran the conversion with the sql file specification, as in the "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.

This file contains the following commands:

cd "S:\Sqlways\Bin\Release"

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

"S:\support\test\Export\sqlways_all.bat"

Runs the import into the target database.


Ispirer Home Page Ispirer SQLWays Migration Product Page Request SQLWays

sqlways/faq/schedule-migration-process.txt · Last modified: March 20, 2013, 03:54:05 AM (external edit)
 
Ispirer Ispirer © 1999-2017, Ispirer Systems Ltd.
All Rights Reserved.  Privacy Statement