Ispirer Home Page
Ispirer SQLWays Migration Product Page
Request SQLWays
You can use environment variables to specify the SERVISE, PASSWORD and USER for the whole run in sqlways_all.bat. But first you need to specify those environment variables in the SQLWays, so that it used them in all the bat files with the commands, like:
The Password is specified as %PASSWORD% here.
So, 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 run using the sqlways_all.bat file with the command like:
sqlways_imp.exe /bat=sqlways_all.bat
So, all that is left to do 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/[email protected] @calendar_ddl.sql
So, changing just three values in the sqlways_all.bat file, you can control which user, password and service name must be used for the whole load.
Ispirer Home Page
Ispirer SQLWays Migration Product Page
Request SQLWays
© 1999-2022, Ispirer Systems Ltd. All Rights Reserved. Privacy Statement |