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

Suppress identical error

While using command line to generate a difference report (in html format), if the two databases are identical, the console output says:

Error: The selected objects are identical or no objects have been selected in the comparison. Use /include:Identical to
suppress this error.

If I include the /include:Identical switch, then the error is not reported on the console, but the output html file has all the objects in it.

I don't want the console error as well as don't want the identical objects in the html file. This is what I want:
1. Don't want to use the /include:Identical switch
2. If the two databases are identical, then the error reported on the console should be suppressed (using some switch)
3. The html file should contain only the summary (in this case, say 29 identical)

Is this possible?
agarg
0

Comments

3 comments

Sort by
  • DanC
    Hi @agarg

    Unfortunately, this is currently the way SQL Compare works, and to change this behavior it would be a feature request.

    I would suggest making a post on the UserVoice forum https://redgate.uservoice.com/forums/141379-sql-compare
    DanC
    0
  • agarg
    Thanks for your reply. I have posted the idea at the link.
    agarg
    0
  • davesbrown
    "Unfortunately, this is currently the way SQL Compare works..."

    It's not how it always worked, it has been a very recent change and has affected my automatic deployments.  I have made the change on my end though.
    davesbrown
    0

Add comment

Please sign in to leave a comment.