Compare 7.1 An Item with the Same Key Has Already Been Added

Chris HowarthChris Howarth Posts: 8
edited October 29, 2008 12:14PM in SQL Compare Previous Versions
I'm getting the following error when using a scripts folder as one 'half' of the compare:

"An item with the same key has already been added"

This occurs at the 'Registering Databases -> Scripts.Main-Processing file:' stage.

If, when the problem occurs, I move the referenced file out of the comparison folder, the next comparison run then fails on the next file.

Is there a limitation on the number of scripts files that can be compared? We currently have just over 5000 files that form our database (one script file per object).

This initially sounded similar to the issue mentioned here:

http://www.red-gate.com/MessageBoard/vi ... php?t=7878

However I obtained a copy of SQL Compare 7.2 and the problem still exists.

Thanks
Chris

Comments

  • This issue has now been resolved - there was a duplicate extended property in one of our scripts. :(

    It took some tracking down though - is verbose logging available in SQL Compare to help track these issues down?

    Chris
  • Hi Chris,

    In the next release we're hoping to improve the feedback provided when such issues occur, which should make troubleshooting a lot easier. Duplicate objects are quite common as well as SQL syntax issues.

    Thanks for highlighting this to us.

    Kind regards,

    David Atkinson
    Product Manager
    Red Gate Software
    David Atkinson
    Product Manager
    Redgate Software
Sign In or Register to comment.