Issues with new Release 10.2.0.696

skuhnskuhn Posts: 27 Bronze 3
edited May 29, 2012 12:23PM in SQL Compare Previous Versions
I recently upgraded to the latest version, 10.2.0.696 and when performing a compare SQL Compare is showing over 200 tables as "existing in both but different". Since we have made very few changes this was very surprising. When I look at the side by side comparison at the bottom, SQL Compare is showing no actual differences on the vast majority of tables.

The compare is performed using Source Control to Database compare for migration to TEST. (Within the source control option I have chosen our DEV database which is linked to source control and the compare is to our TEST database.)
· Share on Twitter

Comments

  • neil.andersonneil.anderson Posts: 64
    Hi Skuhn,

    Can you try the patch build from here:

    ftp://support.red-gate.com/patches/sql_ ... .0.777.zip

    and let me know if it fixes your problem?

    Thanks,
    Neil
    · Share on Twitter
  • skuhnskuhn Posts: 27 Bronze 3
    Hi Neil,

    Yes, that solved my problem. Thank you very much for the quick response!

    Scott Kuhn
    · Share on Twitter
  • DLDMDLDM Posts: 1
    Hi, Neil,

    I was seeing the same problem. I installed the patch and it fixed that particular problem.

    However on a related note, the patch version still appears to be falsely reporting changes for some Stored Procedures that have not changed. Either there are differences that aren't being highlighted, or there aren't any differences and the SP should not have been flagged as changed.
    -Dave
    · Share on Twitter
  • Michael NewcombMichael Newcomb Posts: 3
    I'm having lots of problems with 10.2.0.696 (now upgraded to 10.2.0.777). SQL Compare is showing hundreds of differences between databases that have only minor changes -- if you click the "changed" items no differences show in the compare window.

    Further, SQL Compare started popping a window that says it has "magically mapped the following fields." The mapping it shows makes absolutely no sense and seems random, but I can't figure out how to undo it or to stop it from doing anything magically.

    Is there any way I can roll back to the old version? I can't use the product in its current state.

    Thanks for your help,

    Mike N.
    · Share on Twitter
  • neil.andersonneil.anderson Posts: 64
    DLDM wrote:
    Hi, Neil,

    I was seeing the same problem. I installed the patch and it fixed that particular problem.

    However on a related note, the patch version still appears to be falsely reporting changes for some Stored Procedures that have not changed. Either there are differences that aren't being highlighted, or there aren't any differences and the SP should not have been flagged as changed.
    -Dave

    Hi DLDM,

    Can you give me an example of a SP that you Compare is showing as different now?

    Thanks,
    Neil
    · Share on Twitter
  • neil.andersonneil.anderson Posts: 64
    Michael Newcomb wrote:
    I'm having lots of problems with 10.2.0.696 (now upgraded to 10.2.0.777). SQL Compare is showing hundreds of differences between databases that have only minor changes -- if you click the "changed" items no differences show in the compare window.

    Further, SQL Compare started popping a window that says it has "magically mapped the following fields." The mapping it shows makes absolutely no sense and seems random, but I can't figure out how to undo it or to stop it from doing anything magically.

    Is there any way I can roll back to the old version? I can't use the product in its current state.

    Thanks for your help,

    Mike N.

    Hi Mike,

    Sorry about the problems you are experiencing. What sort of non-sensical mappings are you seeing? Can you give me the definitions of the tables please?

    Are you able to send us snapshots of the databases which are showing invisible differences? If so please send them to support@red-gate.com

    I believe the latest update has not been shipped in the installers on the site so if you uninstall Compare and download it again from
    http://www.red-gate.com/products/sql-de ... l-compare/ you can revert to the older version 10, just don't update it as yet.

    Thanks,
    Neil
    · Share on Twitter
Sign In or Register to comment.