CLI -Turn off output in results

rakshitpatelrakshitpatel Posts: 7
Is there a way to turn off the results when Data Compare CLI is used from SQL server using xp_cmdshell.

Turn off following output:-

Red Gate SQL Data Compare Command Line Utility V7.1.0.245
==============================================================================
Copyright c Red Gate Software Ltd 1999-2008
NULL
NULL

Comments

  • Brian DonahueBrian Donahue Posts: 6,590 New member
    I think xp_cmdshell supports output supression as an option:
    xp_cmdshell 'sqldatacompare.exe', NO_OUTPUT
    
    This should stop the console output from coming back in the SQL Server messages stream.
  • It worked. Thanks for the suggestion.

    I think xp_cmdshell supports output supression as an option:
    xp_cmdshell 'sqldatacompare.exe', NO_OUTPUT
    
    This should stop the console output from coming back in the SQL Server messages stream.
Sign In or Register to comment.