SQL Compare - Interactive HTML Report does not show onlyin1 and onlyin2 differences
modernuniverse
Posts: 10 New member
in SQL Compare
I am comparing a database and a source control folder. Then I am trying to create a report.
There is a discrepancy between Interactive HTML Report and XML report I generate from SQL Compare.
Both reports show the modified objects and identical objects.
However, the XML report shows objects that are not in the database but in the source code folder, and the objects that are in the database but not in the source code folder. (The xml entries show the difference status as status="onlyın1" or status="onlyın2").
On the other hand, the Interactive HTML report does not show any of these.
What am I doing wrong? Does Interactive HTML report have a bug?
I see that Interactive HTML report has "Added" and "Removed" categories. So I expected onlyin1 differences to show up as Removed and onlyin2 differences as Added.
Please help.
There is a discrepancy between Interactive HTML Report and XML report I generate from SQL Compare.
Both reports show the modified objects and identical objects.
However, the XML report shows objects that are not in the database but in the source code folder, and the objects that are in the database but not in the source code folder. (The xml entries show the difference status as status="onlyın1" or status="onlyın2").
On the other hand, the Interactive HTML report does not show any of these.
What am I doing wrong? Does Interactive HTML report have a bug?
I see that Interactive HTML report has "Added" and "Removed" categories. So I expected onlyin1 differences to show up as Removed and onlyin2 differences as Added.
Please help.
Tagged:
Best Answer
-
Eddie D
Posts: 1,803 Rose Gold 5
Hi, thank you for your reply.
Using both V13.6.11.8947 and after upgrading to the recently released 13.7.0.920, I am unable to reproduce the reported problem with the objects with differences option selected. See the image below.
What version of SQL Compare are you using?
Many Thanks
Eddie
Answers
What options have you selected when generating the Interactive HTML Report? Have you selected 'Objects with differences' option or 'Objects selected for deployment' option?
Senior Product Support Engineer
Redgate Software Ltd
Email: support@red-gate.com
- objects with differences
- objects selected for deployment
- objects with differences and also include identical objects
- objects selected for deployment and also include identical objects
None of the html reports generated contain neither onlyin1 nor only2 differences. On the other hand, the xml report contains them.
I do not remember what my version was before.
Thank you.