Parameters into Powershell_ISE from Command Line

Question

I've developed a script in Powershell_ISE to backup a SQL Server database on one server, move the file to another server and restore to the target server with a different database name. Works fine.

It uses 6 mandatory parameters. Within Powershell_ISE I can run

    C:\PowershellScripts\Servers\CRMBackup.ps1 -SrcSrv uk-sb-sql12\wss -SrcDb UAT_2016_MSCRM
     -SrcBak \\uk-sb-sql12\backup\ -TrgSrv uk-sb-sql12\wss -TrgDb preprod_mscrm66 -TrgBak 
     \\uk-sb-sql12\backup\

and it works fine.

I can't get it to run from the Command Line though. How do I achieve this?

If I run

    powershell_ise.exe "C:\PowershellScripts\Servers\CRMBackup.ps1" -SrcSrv uk-sb-sql12\wss 
    -SrcDb UAT_2016_MSCRM -SrcBak \\uk-sb-sql12\backup\ -TrgSrv uk-sb-sql12\wss -TrgDb 
    preprod_mscrm66 -TrgBak \\uk-sb-sql12\backup\

from a Command prompt I get an error:

If I call Powershell instead of Powershell_ISE, all is fine:

    powershell.exe "C:\PowershellScripts\Servers\CRMBackup.ps1" -SrcSrv uk-sb-sql12\wss 
    -SrcDb UAT_2016_MSCRM -SrcBak \\uk-sb-sql12\backup\ -TrgSrv uk-sb-sql12\wss -TrgDb 
    preprod_mscrm66 -TrgBak \\uk-sb-sql12\backup\

completes successfully:

Can anyone advise how to pass command line parameters into Powershell_ISE?

Thanks

put everything in double quotes? I mean powershell_ise.exe doesn't accept such params: powershell_ise.exe -h — Jaqueline Vanek, Aug 26 '16 at 12:01
Is there a specific reason for wanting to launch ISE to execute your script? Isn't the Powershell command line sufficient? — Poorkenny, Aug 26 '16 at 13:32
Agree - why do you need to run with `powershell_ise.exe`? Just run with `powershell.exe` instead. — Bill_Stewart, Aug 26 '16 at 14:54
OK, thanks for the unanimous verdict. @Poorkenny - the progress bar when backing up and restoring databases is so much prettier in Powershell_ISE than Powershell! — DiamondBeezer, Aug 31 '16 at 07:06

score 3 · Accepted Answer · edited May 23 '17 at 12:32

3

You cannot use parameters into Powershell_ISE from Command Line.

Some background:

You use PowerShell ISE to develop your scripts (or notepad or whatever) and you use powershell.exe to execute them when finished. You can execute scripts in different ways:

From a DOS command, calling powershell.exe as you indicate in your question.
From a PowerShell command, calling C:\PowershellScripts\Servers\CRMBackup.ps1
From Windows Task Scheduler (or similar tool...)
From a CI tool (Jenkins, TeamCity...)

Of course you can execute scripts from PowerShell ISE while developing them that can be done by clicking Start (or pressing F5) and you can pass parameters as explained here. But you cannot execute an script passing parameters to powershell_ise.exe.

edited May 23 '17 at 12:32

Community

1
1

answered Aug 26 '16 at 13:41

Oscar Foley

6,817
8
57
90

1

Unfortunately, there are some scripts that run fine via ISE, but not via powershell.exe. – Todd Ropog Apr 04 '17 at 15:31
Not totally correct: you can create a .ps1 and use powershell_ise.exe with the -file parameter. – fcm Feb 17 '18 at 13:20

score 1 · Answer 2 · answered Aug 26 '16 at 13:27

did you try this? (powershell.exe instead of powershell_ise.exe)

powershell.exe "C:\PowershellScripts\Servers\CRMBackup.ps1" -SrcSrv uk-sb-sql12\wss -SrcDb UAT_2016_MSCRM -SrcBak \\uk-sb-sql12\backup\ -TrgSrv uk-sb-sql12\wss -TrgDb preprod_mscrm66 -TrgBak \\uk-sb-sql12\backup\

score 0 · Answer 3 · answered Aug 26 '16 at 12:07

0

Unfortunatelly you cannot start ISE from command line with your parameters. The list of possible parameters that could only customize your session is here:

https://technet.microsoft.com/en-us/library/hh847883

answered Aug 26 '16 at 12:07

paul543

178
4
16

Parameters into Powershell_ISE from Command Line

3 Answers3