/mfx in SQL Compare 12?
DavidBrower
Posts: 3 New member
in SQL Compare
We have just moved from SQL Compare 10 to SQL Compare and have found that some of our automated scripts are no longer working due to the following switch no longer being recognised.
We have a powershell script that is run inside Octopus Deploy:
We then get the following message:
For the life of me (today is the first day working with SQL Compare) I cannot find what the equivalent switch is in SQL Compare 12.
We have a powershell script that is run inside Octopus Deploy:
$base_args = ( "/sourcecontrol1", "/versionusername1:$username", "/versionpassword1:$password", "/sfx:`"$scriptFile`"", "/r1:$revision", "/mfx:`"$migrationFile`"", "/s2:$dbServer", "/db2:$dbName", "/Options:$dbCompareConfig") Write-Host "Executing DB Compare using Script File: $scriptFile and Migration File: $migrationFile" Write-Host "Generating comparison report for $dbName on $dbServer" $report_args = $base_args | foreach { $_ } $report_args += "/Report:`"$reportHtmlFile`"" $report_args += "/ReportType:Interactive" Start-Process -FilePath $sqlcompare -ArgumentList $report_args -NoNewWindow -Wait -ErrorAction SilentlyContinue New-OctopusArtifact $reportHtmlFile
We then get the following message:
Error: Invalid command-line argument: /mfx. Please use SQLCompare.exe /? or SQLCompare.exe /verbose /? for more
For the life of me (today is the first day working with SQL Compare) I cannot find what the equivalent switch is in SQL Compare 12.