I found a bug

• 
  To help us repro the problem at our end, can you tell us the steps you took to make this happen?

  Alice E December 16, 2009 11:49

  - 0 +
• 
  Nothing special. I just selected the database and schema and clicked compare. I then noticed that it showed me differences in other schemas on the comparison screen.

  bcpreece December 16, 2009 11:51

  - 0 +
• 
  Was it a brand new project?
  Were you comparing databases or snapshots?
  Did you have any options set?
  If you close the project and start a new one, select a schema, does it still show you all of them?

  Alice E December 16, 2009 11:52

  - 0 +
• 
  Was it a brand new project? - Yes
  
  Were you comparing databases or snapshots? - Databases
  
  Did you have any options set? - Default options
  
  If you close the project and start a new one, select a schema, does it still show you all of them? - Yes it shows all schemas every time I compare

  bcpreece December 16, 2009 11:56

  - 0 +
• 
  If there are dependent objects between schemas, they'll be pulled in for the comparison, because if you choose to sync the objects without their dependencies the database could be left in an invalid state.
  
  e.g. if you have an object with a dependency on a table in a schema you haven't chosen to compare, that table will show up in the comparison results (and the sync script, if you choose to sync dependencies).
  
  I think that's what's happening here - can you let us know if that's the case?
  
  Do you think this is useful behaviour? What would your expectations be in this situation?

  Alice E December 16, 2009 12:08

  - 0 +
• 
  That is most likely the case. I would need to use the tool more to know if this is helpful or not. My first instinct would be not to show dependencies unless there is changes contained in the dependencies or if I selected to show them.

  bcpreece December 16, 2009 12:11

  - 0 +
• 
  OK. Thanks for all your feedback so far, we really appreciate it!

  Alice E December 16, 2009 12:18

  - 0 +

Add comment

Please sign in to leave a comment.