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/09/20 12:27] darya.prikhodkina |
— (current) | ||
|---|---|---|---|
| Line 1: | Line 1: | ||
| - | ====== How to Schedule Migration Process ====== | ||
| - | |||
| - | 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: | ||
| - | |||
| - | 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|"SQLWays Command Line"]]. | ||
| - | |||
| - | "S:\support\test\Export\sqlways_all.bat" | ||
| - | |||
| - | Runs import into the target database. | ||
| - | |||
| - | \\ | ||
| - | ---- | ||
| - | === More about Ispirer Systems === | ||
| - | [[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]] | ||