Suppress identical error

agarg

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?

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

agarg

Thanks for your reply. I have posted the idea at the link.

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.