How can we help you today? How can we help you today?

CLI -Turn off output in results

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
rakshitpatel
0

Comments

2 comments

Sort by
  • Brian Donahue
    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.
    Brian Donahue
    0
  • rakshitpatel
    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.
    rakshitpatel
    0

Add comment

Please sign in to leave a comment.