compare - xml command line

tthorne

What is the syntax/tags to call a project using xml for the return?

Michelle T

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?

tthorne

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.

Michelle T

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.