Differences
This shows you the differences between two versions of the page.
Both sides previous revision Previous revision | |||
faq:migration-toolkit:schedule-migration-process [2022/05/24 15:23] vladimir.gribok removed |
— (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]] | ||