Differences
This shows you the differences between two versions of the page.
Next revision | Previous revision Next revision Both sides next revision | ||
faq:migration-toolkit:schedule-migration-process [2018/05/07 05:15] 127.0.0.1 external edit |
faq:migration-toolkit:schedule-migration-process [2019/09/20 12:26] darya.prikhodkina |
||
---|---|---|---|
Line 1: | Line 1: | ||
- | \\ | ||
- | [[http://www.ispirer.com|Ispirer Home Page]] | ||
- | [[http://www.ispirer.com|Ispirer SQLWays Migration Product Page]] | ||
- | [[http://www.ispirer.com/?click=RequestSQLWays&from=IspirerWIKI|Request SQLWays]] | ||
- | |||
====== 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 12: | 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. |
\\ | \\ | ||
- | [[http://www.ispirer.com|Ispirer Home Page]] | + | ---- |
- | [[http://www.ispirer.com|Ispirer SQLWays Migration Product Page]] | + | === More about Ispirer Systems === |
- | [[http://www.ispirer.com/?click=RequestSQLWays&from=IspirerWIKI|Request SQLWays]] | + | [[https://www.ispirer.com|Ispirer Home Page]] |
+ | [[https://www.ispirer.com/products/database-migration|Database Migration]] | ||
+ | [[https://www.ispirer.com/application-conversion|Application Conversion]] | ||
+ | [[https://www.ispirer.com/download|Downloads]] | ||