Competition: What’s your favorite Redgate tool? Enter now.

How to export Comparison Results

clairehclaireh Posts: 14
edited May 27, 2007 7:34PM in SQL Compare Previous Versions
Hi,

I have successfully using command line to generate database snapshots through SQL Compare command line.

Now i would need to compare the snapshots I took and generate reports. Could anyone please advise how to generate comparison reports, with different format avaiablibity

I tried with the following command but didnt get any thing readable

sqlcompare.exe" /snapshot1:"Server1_MyDB.snp" /snapshot2:"Server2_MyDB.snp" /report:"DB_Difff.rpt"

Thanks
Claire

Comments

  • When you output a report using SQL Compare Command line, you also need to specify what type of report you want to create.

    You need to use the /reporttype switch.

    /reporttype:<reporttype> alias:/rt [default: XML]

    Values: XML, Simple, Interactive, excel

    Once you have set the reporttype switch you will need to set the file for the report using /report, and specifying the file name and the file extension for the type of report you have chosen.

    e.g. /reporttype:interactive /report:MyReport.html

    You can view this in more detail by looking at the SQL Compare command line help file.

    Type this command after navigating to the SQL Bundle 5 installation directory.
    SQLCompare /help /verbose
    Chris
Sign In or Register to comment.