Non DBO Owner objects always show as different

• 
  Many thanks for your post.
  
  When you create a comparison project and you have selected your data sources, SQL Compare automatically maps objects with the same name and the same owner (SQL Server 2000) or schema (SQL Server 2008 and SQL Server 2005) for you.
  
  If you want to compare objects with the same name, but those objects have different owners or belong to different schemas, you can map the owners or schemas as required. For example, if you want to compare objects in a test database that are owned by sales with objects in a production database that are owned by support, you can map sales to support.
  
  For more details kindly go throughthis knowledge base article.

  Anu D September 01, 2010 04:36

  - 0 +
• 
  Did my previous suggestion helped you?

  Anu D September 07, 2010 05:25

  - 0 +
• 
  Sorry Anu,
  
  Got sidetracked onto some other projects and just now returning to this issue. The owners are the same in both databases, however when I compare the databases they show are different.
  
  I can upload the actual compare output if that would assist.

  thom.bolin December 13, 2010 10:38

  - 0 +
• 
  the owners in both databases are the same, but neither is dbo. Is there a work around/fix for this issue.
  
  I can attach the output comparision if needed.

  thom.bolin January 06, 2011 15:42

  - 0 +

Add comment

Please sign in to leave a comment.