Automating a MS-DOS batch file, when password has to be entered manually

Question

I want to automate a MS-DOS command which requires a password, however the password can not be passed as one of the command line options. How can I do this?

The command I want to run is

dumpdata --schema=mydb mytable C:\temp\output.sql

[This command extracts data from an Oracle database in the form of Insert statements]

There is then a prompt for the password, which needs to be entered manually.

Removing the password (from the database) is not an option, as per Writing a batch file that enters a password when prompted

Thank you!

Cyclonecode · Accepted Answer · 2012-03-18T15:44:05.933

2

If I understand it correctly you should set up an environment variable named ORA_USERID containing your username/password. If not set than you will be prompted for the password when connecting using the dumpdata command. Checkout OracleTools.

edited Mar 18 '12 at 15:44

answered Mar 18 '12 at 15:37

Cyclonecode

29,115
11
72
93

Thank you very much. In fact (after following the instructions on the link) I simply replaced --schema=mydb with --scheme=mydb/mypassword – gordon613 Mar 18 '12 at 15:47
Yes, I found that you could achive the same thing that way too. Nice you solved it though. – Cyclonecode Mar 18 '12 at 15:48

score 1 · Answer 2 · answered Mar 18 '12 at 15:35

1

If dumpdata can read from a pipe, this may work:

echo PASSWORD | dumpdata --schema=mydb mytable C:\temp\output.sql

answered Mar 18 '12 at 15:35

benesch

5,239
1
22
36

Hi! Thanks for this answer... It didn't work in my particular case, always good to know though! – gordon613 Mar 18 '12 at 15:57
Sure thing! Glad you found someone who was familiar with `dumpdata`! – benesch Mar 18 '12 at 15:59

Automating a MS-DOS batch file, when password has to be entered manually

2 Answers2