[SA 9.0.176 Pro] SCS Compare does not find all differences?

[SA 9.0.176 Pro] SCS Compare does not find all differences?

I prefer using Beyond Compare but when I right click my repository and do "compare repository to database" it doesn't launch Beyond Compare, but also the SQL Assistant compare window didn't pick up the new column I added (for testing the other Workspace post I made about changed/unchanged files always being red?)

Last edited by Mindflux on Fri Oct 28, 2016 10:32 am; edited 1 time in total

I have submitted this issue for further investigation

	SysOp wrote:
	I have submitted this issue for further investigation

Ok, Please also add that it does not launch a third party compare tool even if set to do so in the options.

I already did.

	SysOp wrote:
	I already did.

Thanks!

Also "show differences" right click from the database explorer doesn't invoke the external compare tool either.

But "show differences" on the left pane (Workspace) does invoke the external compare tool.

	Mindflux wrote:
	Also "show differences" right click from the database explorer doesn't invoke the external compare tool either. But "show differences" on the left pane (Workspace) does invoke the external compare tool.

Thank you. This is very valuable information

This seems to invoke BC now so that's fixed.

HOWEVER: Using the SQL Assistant compare tool still doesn't catch the differences.

In your SQL Assistant options in Source Control tab -> SCS Settings -> External Compare Tool option please replace "Beyond Compare" with full path to the executable file. Does that help?

	SysOp wrote:
	In your SQL Assistant options in Source Control tab -> SCS Settings -> External Compare Tool option please replace "Beyond Compare" with full path to the executable file. Does that help?

Using BC finds the differences, the bug here was that the SQL Assistance compare tool doesn't find them all. You can see my working copy has a [stamp] column that I added to test the compare tool. So I guess the bug here is the comparison tool SQL Assistance uses isn't accurate... which is why I am using BC.

I logged the issue with internal compare tool not finding the differences under #SA0029784 number. Our developers reviewed your screenshots demonstrating the issue, but so far they say they are unable to reproduce it. May I ask you to save and email a couple of files with differences ignored to the support account for further analysis? What we need is files from your SQL Assistant SCS workspace and files created from the code stored in SCS repository. For the latest can you please use an external tool to save them somewhere else? If you use SQL Assistant, it would overwrite files in the repository.

SysOp wrote:

I logged the issue with internal compare tool not finding the differences under #SA0029784 number. Our developers reviewed your screenshots demonstrating the issue, but so far they say they are unable to reproduce it. May I ask you to save and email a couple of files with differences ignored to the support account for further analysis? What we need is files from your SQL Assistant SCS workspace and files created from the code stored in SCS repository. For the latest can you please use an external tool to save them somewhere else? If you use SQL Assistant, it would overwrite files in the repository.

Email and files sent.

This bug has been confirmed and reproduced. It's specific to 64-bit version of SQL Assistant SQL Editor, and it's going to be fixed soon.

This seems like the second or third bug recently that only impacts 64 bit SQL Editor. What is it about the bit-ness of the editor that makes these crop up?

That's a good question. To the best of my knowledge a large portion of the code has been converted from the 32-bit version originally developed for 32-bit environments. There have been also many changes done specific to 64-version to support 64-bit database drivers and such. I think in a few places like Git interface the converted code isn't fully compatible with 64-bit environments, I mean native 64-bit code running on 64-bit systems, not 32-bit on 64-bit. The overall extensive testing we've done and the following beta haven't reveled some issues. My feeling based on the continuing decrease in the volume of issues reported weekly is that most of the issues have been taken care of, but there are few remaining issues and we are trying to address them as quickly as they are discovered. It's of course possible that something else might be found.