How can we help you today? How can we help you today?

Unable to create report from Command Line

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
odellw
0

Comments

1 comment

  • 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
    JonathanWatts
    0

Add comment

Please sign in to leave a comment.