Using subprocess to run an executable with multiple parameters

Question

The command line looks like this:

cd C:\Program Files\Microsoft SQL Server\150\COM

snapshot.exe -Publisher [publisher] -PublisherDB [TEST] -Distributor [dist] -Publication [merge] -ReplicationType 2 -DistributorSecurityMode 1

So two commands in total

so far I have had some luck with:

subprocess.run(["C:\\Program Files\\Microsoft SQL Server\\150\\COM\\snapshot.exe","-Publisher [publisher] -PublisherDB [TEST] -Distributor [dist] -Publication [merge] -ReplicationType 2 -DistributorSecurityMode 1"])

This runs the snapshot.exe but says -Publisher [publisher] -PublisherDB [TEST] -Distributor [dist] -Publication [merge] -ReplicationType 2 -DistributorSecurityMode 1"] is not a valid parameter.

I expect each argument to snapshot.exe needs to be a separate entry in the array, viz, subprocess.run(["C:\\Program Files\\Microsoft SQL Server\\150\\COM\\snapshot.exe","-Publisher","[publisher]", "-PublisherDB", "[TEST]", "-Distributor", "[dist]", "-Publication", "[merge]", "-ReplicationType", "2", "-DistributorSecurityMode", "1"]) — jstell
– jstell, Commented Dec 18, 2020 at 20:06

tripleee · Accepted Answer · 2020-12-18 20:20:26Z

1

Each separate string needs to be a separate string in the call to run, too.

The cd might not be necessary (most sensible tools don't care which directory they run in) but I'll add a cwd parameter too just to show how it can all be done in a single call.

subprocess.run(
        ["C:\\Program Files\\Microsoft SQL Server\\150\\COM\\snapshot.exe"
        "-Publisher", "[publisher]", "-PublisherDB", "[TEST]",
        "-Distributor", "[dist]", "-Publication", "[merge]",
        "-ReplicationType", "2", "-DistributorSecurityMode", "1"],
    # probably drop this
    cwd="C:\\Program Files\\Microsoft SQL Server\\150\\COM",
    # probably add this
    check=True)

edited Dec 18, 2020 at 20:20

answered Dec 18, 2020 at 20:10

tripleee

192k37 gold badges318 silver badges367 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Using subprocess to run an executable with multiple parameters

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related