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

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?

Best Answer

Answers

  • nmwaelnmwael Posts: 4 New member
    edited August 26, 2020 10:57AM
    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?
Sign In or Register to comment.