Second /Option Parameter will be ignored in powershell

schnandr · June 11, 2013 6:59AM

I am using the following code in powershell to compare a db

function CompareDB&#40;$destServer&#41;
&#123;
	$destServerAdj = $destServer -replace "\\","_"
	sqlcompare /Options:Default,ForceColumnOrder /scr1:..\Database /s2:$destServer /u2:user /p2:pwd /db2:DWH /ftr:.\dbcompare.scpf /sf:.\$destServerAdj"-DWH-sync".sql /force
&#125;

My Problem is that the second option Parameter ForceColumnOrder will be ignored. I tested it with multiple parameters and it seems that it is a general problem that the second parameter will be ignored when you call sqlcompare in powershell. Any solution for this?

schnandr · June 11, 2013 7:46AM

Found the solution. Just put the option parameters in quotes

function CompareDB&#40;$destServer&#41; 
&#123; 
   $destServerAdj = $destServer -replace "\\","_" 
   sqlcompare /Options:"Default,ForceColumnOrder" /scr1:..\Database /s2:$destServer /u2:user /p2:pwd /db2:DWH /ftr:.\dbcompare.scpf /sf:.\$destServerAdj"-DWH-sync".sql /force 
&#125;

Eddie D · June 13, 2013 9:35AM

Hi Schnandr

Thank you for your post and excellent news you found the solution to your problem. I will add this to our knowledge base and hopefully other users will benefit.

Many Thanks
Eddie

Second /Option Parameter will be ignored in powershell

Comments

Product Learning

Community Forums

Events & Friends

Simple Talk