SQL Data Compare Professional 14, UI works, commandline does not
nmwael
Posts: 4 New member
Hi I have an odd issue..
If I run below on windows
If I run below on windows
SQLDataCompare.exe /server1:10.160.167.9\MSSQL2016 /database1:SkatScriptDB2 /Include:table:\[dbo\]\.\[IVRMenuStats\] /server2:10.160.167.66 /database2:SkatScriptDB2_shadow SkatScriptDB2_shadow /mts:500 /sync /options:CaseSensitiveObjectDefinitionit fails with this error:
SQL Data Compare Command Line V14.2.9.15508 ====================================================================================================================== Copyright © Red Gate Software Ltd 2020 SQL Data Compare: activated, edition professional Registering databases Mapping Comparing databases Error: Nothing to compare. Either there are no tables/views that can be compared, or everything has been filtered out with /include or /exclude. Use /Include:Identical to see tables/views that exist in both databases but could not be compared. Nothing to compare. Either there are no tables/views that can be compared, or everything has been filtered out with /include or /exclude. Use /Include:Identical to see tables/views that exist in both databases but could not be compared. RedGate.Legacy.CommandLine.FatalExecutionException at RedGate.SQLToolsCommandLine.FatalExecutionExceptionHelper.Throw(ExitCodes exitCode, Exception e) at RedGate.SQLToolsCommandLine.CommandProcessor.ProcessThreadException(Exception e) at RedGate.SQLDataCompare.CommandLine.DataCommandProcessor.ProcessThreadException(Exception e) at RedGate.SQLToolsCommandLine.CommandProcessor.ProcessThreadException() at RedGate.SQLToolsCommandLine.CommandProcessor.RunComparison() at RedGate.SQLToolsCommandLine.CommandProcessor.ProcessCommands() at RedGate.SQLToolsCommandLine.CommandProcessor.Run() Caused by: Nothing to compare. Either there are no tables/views that can be compared, or everything has been filtered out with /include or /exclude. Use /Include:Identical to see tables/views that exist in both databases but could not be compared. RedGate.SQLToolsCommandLine.NothingToCompareExceptionIf I do the same with UI it works as expected... Any Ideas on what might be wrong?
Answers
DID work, so the golden question are what is wrong with the command line?