Hello,
Im attempting to write a script that runs .sql files. I have several
databases, Id like the script to log into each database, do some queries
to check the data, and based on those queries decided to run a given
.sql file or not.
Ive been using perl and dbi, however Ive always run SQL statements from
a file using the meta-command \i. However DBI seems to choke on this.
Running the files from the shell doesn't work due to the script tripping
on the password prompt (which I cannot get around on this setup).
Does anyone have any suggestions on how I can either run meta commands
via DBI or dodge the password prompt without changing the security
setup? Or maybe a different approach entirely.
Thank you for any suggestions,
-A Gilmore