Differences

This shows you the differences between two versions of the page.

--- knowledge-base:database-migration:ispirer-toolkit-faq:migration-schedule [2009/08/26 13:18]
+++ knowledge-base:database-migration:ispirer-toolkit-faq:migration-schedule [2023/11/27 13:29] (current)
@@ Line 1: / Line 1: @@
+\\
+[[https://www.ispirer.com|Ispirer Website]]
+[[https://www.ispirer.com/products/migration-toolkit|Ispirer Toolkit Overview]]
+[[https://www.ispirer.com/download/download-demo|Free Trial]]
+====== How to Schedule Migration Process ======
+After you run the conversion with the sql file specification, as in the [[guides:migration-toolkit:sqlways-wizard:database-migration-guide:objects-selection|Objects Selection]] 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_SAMPLE /U=db2admin /P=Pwd /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 [[guides:migration-toolkit:command-line:options|Command-line Options]] article.
+  "S:\support\test\Export\sqlways_all.bat"
+Runs the import into the target database.