Parameterize login information after import script generation

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