Differences
This shows you the differences between two versions of the page.
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. |
\\ | \\ |