SQL Data Compare Professional 14, UI works, commandline does not

nmwael

Hi I have an odd issue..

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:CaseSensitiveObjectDefinition

it 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.NothingToCompareException

If I do the same with UI it works as expected... Any Ideas on what might be wrong?

nmwael

removing /options:CaseSensitiveObjectDefinition fixed the problem.

nmwael

running

C:\Program Files (x86)\Red Gate\SQL Data Compare 14>SQLDataCompare.exe /project:"C:\sync.sdc"
SQL Data Compare Command Line V14.3.3.16559
======================================================================================================================
Copyright © Red Gate Software Ltd 2020

SQL Data Compare: activated, edition professional
Registering databases
Mapping
Comparing databases
Finished

Summary Information
=======================================================================================================================
DB1 = 10.160.167.66.SkatScriptDB2
DB2 = 10.160.167.66.SkatScriptDB2_shadow

Object type     Name                                                                              Records      DB1 DB2
-----------------------------------------------------------------------------------------------------------------------
Table           [dbo].[IVRMenuStats]                                                                        1  <>  <>
Table           [dbo].[IVRMenuStats]                                                                        1  >>
-----------------------------------------------------------------------------------------------------------------------

DID work, so the golden question are what is wrong with the command line?