Calling SQL updates from Command Prompt
-
Hey, I am wondering if it is possible, and what would be the best way? I'm working on a batch process to take care of building our applications, push/pull from source control and update the databases. As far as updating the DB, there will be a few scripts that need to run and I would like to call them from the same batch process that updates our executables (I really don't want to run a batch file AND set up a SQL job). The goal is to have a single (1) job which will take care of everything to reduce the chance of error. Can someone point me in the right direction? Thanks, Pualee
-
Hey, I am wondering if it is possible, and what would be the best way? I'm working on a batch process to take care of building our applications, push/pull from source control and update the databases. As far as updating the DB, there will be a few scripts that need to run and I would like to call them from the same batch process that updates our executables (I really don't want to run a batch file AND set up a SQL job). The goal is to have a single (1) job which will take care of everything to reduce the chance of error. Can someone point me in the right direction? Thanks, Pualee
For oracle you can use sqlplus calls, for Sql Server you can use iSql.
Mike Lasseter
-
For oracle you can use sqlplus calls, for Sql Server you can use iSql.
Mike Lasseter