Owner mapping in schema compare

• 
  Hello,
  
  Yes! There is a Map Owners button in the bottom-left of the edit project window.

  Brian Donahue August 04, 2006 05:17

  - 0 +
• 
  Thank you for prompt response.
  The source db (2000) has owner x for table a, and owner y for table b. The target db (2005) has schema y for table a, and schema y for table b.
  So the owner mapping looks like:
  x -> y for table a
  y -> y for table b
  The Schema Compare fails during the compare step with the error "Item has already been added. Key in dictionary: "table a". Key being added: "table a"."
  I think I've got that described correctly. I understand why the error occurs. I could fix this manually by externally changing the owners to be consistent. Having to fix it externally obviates the use of the Schema Compare program. A solution might be to be able to filter out the offending table so the compare completes for the remaining objects. Would appreciate your feedback and suggestions.

  mfarbstein August 04, 2006 12:37

  - 0 +
• 
  I haven't got any suggestions, but this is a known potential issue that can happen with the software, when you have two identically named tables with different ownership, then try to map these two owners together.

  Brian Donahue August 05, 2006 13:19

  - 0 +

Add comment

Please sign in to leave a comment.