Options

CLI -Turn off output in results

rakshitpatelrakshitpatel Posts: 7
edited March 30, 2009 11:31AM in SQL Data Compare Previous Versions
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
· Share on Twitter

Comments

  • Options
    Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
    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.
    · Share on Twitter
  • Options
    rakshitpatelrakshitpatel Posts: 7
    It worked. Thanks for the suggestion.

    Brian Donahue wrote:
    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.
    · Share on Twitter
Sign In or Register to comment.