compare - xml command line

• 
  The syntax to call SQLCompare.exe using a project for the settings and outputting an XML report is the following:
  
  SQLCompare.exe /project:<project file name and path> /report:<path and file name of desired output file>
  
  e.g. SQLCompare.exe /project:"C:\Project Directory\myproject.scp" /report:"C:\Report Directory\myreport.xml"
  
  Is that what you were looking for?

  Michelle T January 09, 2008 06:18

  - 0 +
• 
  That helped thanks - couple of other questions:
  
  Does Red Gate compare all db programming for sql server (2000 & 2005). I need something that will also compare things such as DTS, SSIS, etc .
  
  For auditors, my goal is to automate a process and send daily reports on changes to any/all code on a SQL database. The generate scripts is a step in the right direction.

  tthorne January 09, 2008 10:01

  - 0 +
• 
  Unfortunately, SQL Compare does not compare DTS, SSIS, or server-level objects. It only compares database objects.
  
  We used to sell a product called DTS Package Compare which compares DTS, and you can still get the (now unsupported) final release if you want (see http://www.red-gate.com/products/DTS_Pa ... /index.htm for details).
  
  I've linked this forum thread to the feature requests asking for comparisons of SSIS and server-level objects.

  Michelle T January 09, 2008 11:12

  - 0 +

Add comment

Please sign in to leave a comment.