What are the challenges you face when working across database platforms? Take the survey

Key already exists

Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
edited December 14, 2004 12:44PM in SQL Compare Previous Versions

Thanks for asking! Most of the time, you can prevent this error by using the 'treat items as case-sensitive' option.

The error is occurring because you have a case-sensitive server collation and the SQL Compare is indexing items by their name, which results in the software trying to store objects with identical key names.


This discussion has been closed.