Differences

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

--- faq:migration-toolkit:load-parameterization [2019/07/25 10:29]
darya.prikhodkina
+++ — (current)
@@ Line 1: / Line 1: @@
-====== How to Parameterize Login Information After Generation of Import Script ======
-You can use environment variables to specify the **SERVISE**, **PASSWORD** and **USER** for the whole run in //**sqlways_all.bat**//. But firstly you need to specify these environment variables in SQLWays Wizard, so that it could them in all the bat files with the commands, like:
-{{:faq:migration-toolkit/load-parameterization.png|}}
-The Password is specified as **%PASSWORD%** here.
-As the result you will have bat files for data and ddl loading with the commands like, e.g. for Oracle:
-  sqlplus %USER%/%PASSWORD%@%SERVICE% @calendar_ddl.sql
-All the bat files are ran using the //**sqlways_all.bat**// file with the command like:
-  sqlways_imp.exe /bat=sqlways_all.bat
-So all that is left is to update the //**sqlways_all.bat**// file with the following **SET** commands before the **CALL** statements:
-  set USER=ora
-  set PASSWORD=pass
-  set SERVICE=ora
-As the result the **SQLPLUS** command will be executed as follows:
-  sqlplus ora/pass@ora @calendar_ddl.sql
-As you can see, by changing just three values in the sqlways_all.bat file, you can control which user, password and service name is to be used for the whole load.
-\\
-----
-=== 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]]