How can we help you today? How can we help you today?

An item with the same key has already been added.

I have a database (SQL 2008) and when I compare to a script folder I get the error: An item with the same key has already been added. The database has a filtered index on one table. The scrip folder has a script with the same filtered index but on another table. If I remove the filtered index from the script I do not get the error.
jthamdrup
0

Comments

4 comments

Sort by
  • Brian Donahue
    Hello,

    Please let us know the version of SQL Compare you're using. 8.0 and maybe even 8.1 had some problem with partitioned data, which is what I think you are telling us. Check for Updates on the help menu will get you up to 8.1; if the problem still happens in 8.1, there is also the "cumulative patch" you can try (see the sticky topic near the top of the forum).
    Brian Donahue
    0
  • jthamdrup
    I'm using version 8.1.0.360. Running Check for Updates returns No updates available. I've sent a example of how to reproduce the issue in an e-mail
    jthamdrup
    0
  • David Atkinson
    The latest cumulative patch isn't available on Check for Updates yet. You can find it linked from here:

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

    Let us know whether this fixes your issue.

    Thanks!

    David Atkinson
    Red Gate Software
    David Atkinson
    0
  • jthamdrup
    No, it did not fix the issue. I've provided more info in a seperate e-mail
    jthamdrup
    0

Add comment

Please sign in to leave a comment.