The Item with the same key has already been added

alexey

I'm trying to compare databases and my SQLCompare 7.1 says "The Item with the same key has already been added" when reading source Live Database. However if I script the same DB and then run SQLCompare against script file it runs Ok. Can anybody give me a hint of what the problem might be or how can I troubleshoot it?

Thanks

Michelle T

Usually this is a case sensitivity problem (the database is case sensitive but the option 'Treat items as case sensitive' is off, causing two objects to appear to have the same name).

You could also turn on logging (from the 'icon menu', the menu from the SQL Compare icon in the top left-hand corner) and see at what stage in the registration process the exception is being thrown, which might tell you which object is causing the problem.

alexey

Thanks for reply.
I’ve checked the case sensitivity check box, and unchecked Ignore spaces. It didn’t make any difference. I pushed logging to Verbose and that’s the log file I’ve got:

13:00:06.630|Info |Logging |1 |Current Logging levels enabled: Verbose,Warning,Fatal,Debug,Information,Trace,Error
13:00:48.866|Info |SQL Compare Engine |7 |Register live database start: {0}RPM
13:00:48.944|Info |SQL Compare Engine |7 |Populate Live Start, popoptions: 264
13:00:48.944|Info |SQL Compare Engine |7 |Populate Live Start, options: IgnoreWhiteSpace, CaseSensitiveObjectDefinition, NoSQLPlumbing, IncludeDependencies, IgnoreFileGroups, ConsiderNextFilegroupInPartitionSchemes, IgnoreUserProperties, IgnoreWithElementOrder, AddDatabaseUseStatement, DecryptPost2kEncryptedObjects
13:00:48.960|Info |SQL Compare Engine |7 |Populate major version: {0}SqlServer2008
13:00:48.975|Info |SQL Compare Engine |7 |Populate got casing: True
13:00:48.975|Info |SQL Compare Engine |7 |Populate Case Sensitive: True
13:00:49.022|Info |SQL Compare Engine |7 |Populate FulltextCatalogs start.
13:00:49.116|Info |SQL Compare Engine |7 |Populate Fulltext Stoplists start.
13:00:49.131|Info |SQL Compare Engine |7 |Populate Fulltext Stopwords start.
13:00:49.131|Info |SQL Compare Engine |7 |Populate ObjectNames start.
13:00:49.178|Info |SQL Compare Engine |7 |Populate Users start.
13:00:49.194|Info |SQL Compare Engine |7 |Populate Tables start.
13:01:08.399|Info |SQL Compare Engine |7 |Register live database start: {0}RPM
13:01:08.399|Info |SQL Compare Engine |7 |Populate Live Start, popoptions: 264
13:01:08.399|Info |SQL Compare Engine |7 |Populate Live Start, options: CaseSensitiveObjectDefinition, NoSQLPlumbing, IncludeDependencies, ConsiderNextFilegroupInPartitionSchemes, AddDatabaseUseStatement, DecryptPost2kEncryptedObjects
13:01:08.415|Info |SQL Compare Engine |7 |Populate major version: {0}SqlServer2008
13:01:08.415|Info |SQL Compare Engine |7 |Populate got casing: True
13:01:08.415|Info |SQL Compare Engine |7 |Populate Case Sensitive: True
13:01:08.477|Info |SQL Compare Engine |7 |Populate FulltextCatalogs start.
13:01:08.477|Info |SQL Compare Engine |7 |Populate Fulltext Stoplists start.
13:01:08.477|Info |SQL Compare Engine |7 |Populate Fulltext Stopwords start.
13:01:08.477|Info |SQL Compare Engine |7 |Populate ObjectNames start.
13:01:08.508|Info |SQL Compare Engine |7 |Populate Users start.
13:01:08.508|Info |SQL Compare Engine |7 |Populate Tables start.

It doesn’t report any specific issues related to DB. Can I do anything else to locate the problem?