Activity overview
Latest activity by schnandr
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.
Commandline Option AddDatabaseUseStatement missing
Hi,
I am using data compare via command line. Is there also an option like AddDatabaseUseStatement in sql data compare like in sql compare?
Thanks
Andi
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...
Second /Option Parameter will be ignored in powershell
I am using the following code in powershell to compare a dbfunction CompareDB($destServer)
{
$destServerAdj = $destServer -replace "\\","_"
sqlcompare /Options:Default,ForceColumnOrd...