1.

Solve : Run a batch file to produce results in cmd?

Answer»

i am new to MS dos and SQL and i was wondering if you can help me

I am TRYING to run a batch file and produce some results in ms dos

i dont know what command i need to use

i have created the bat file and a text file and i want to run the batch (bat) file to run that command in the txt file

and produce the results in CMD command prompt. can you help me with this one please?
Are you trying to pass SQL instructions from batch to SQL at command line?

I have been successful in doing this for batch files that backup and RESTORE the database from dump files. What are you trying to do with your instructions that are in the text file? You may not need the text file to begin with and might be able to contain it all within the batch file for the batched SQL instructions.

The only thing dangerous about use of batch for ACCOMPLISHING this is that the root permissions for the database are in PLAIN sight in the batch file, so if your the only one USING it your all set, but if you dont want others seeing the admin privilege credentials of your database then its too easy for someone to open up the batch file in an editor and see your root password etc.



Discussion

No Comment Found