Comments
Sort by recent activity
OK, thanks. I found a good workaround with /include:StaticData with SQL Compare. / comments
OK, thanks. I found a good workaround with /include:StaticData with SQL Compare.
Found the solution. Just put the option parameters in quotes
function CompareDB($destServer)
{
$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
}
/ comments
Found the solution. Just put the option parameters in quotes
function CompareDB($destServer)
{
$destServerAdj = $destServer -replace "\\","_"
sqlcompare /Options:"Default,Forc...