Unable to create report from Command Line

odellw

It seems to be working now, once I piped the the output to a text file.

When running from the command line I recieve the following error:

---

The filename, directory name, or volume label syntax is incorrect.

The command I am using is as follows"

sqlcompare /database1:TSysBB /database2:TSysBB /s1:tlab5 & /username1:sa /s2:TLAB5\TSYSTEM /username2/sa /options:Default /ecxlude:ROle /reportrtype:SImple:c:\test1.html

It does the compare correctly but it is not generating a report.

I am using SQLCOMPARE version 5.2.0.32

Thanks for any insight

JonathanWatts

Hi there

Ah, I think the problem is that you need to specify the report file and the report type separately. Something the below should be ok:

sqlcompare /database1:pubs /database2:northwind /s1:(local) /s2:(local) /options:Default /exclude:Role /reporttype:Simple /report:c:\test1.html

Let us know if you have any more trouble.

Regards,

Jonathan