An item with the same key has already been added.

jthamdrup · February 25, 2010 11:51AM

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.

Brian Donahue · February 26, 2010 1:23PM

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).

jthamdrup · February 26, 2010 1:33PM

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

David Atkinson · February 26, 2010 2:23PM

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

jthamdrup · March 10, 2010 7:07PM

No, it did not fix the issue. I've provided more info in a seperate e-mail

An item with the same key has already been added.

Comments

Product Learning

Community Forums

Events & Friends

Simple Talk