Multiple schemas comparison does not work

Comments

• Alice E Redgate › Posts: 108

  July 19, 2010 7:33AM

  Thanks for your post.
  
  I'm afraid Schema Compare for Oracle doesn't support one-to-many mappings of a source schema to multiple target schemas (or vice versa).
  
  The main intended use case is to allow users to see the differences between individual schemas: we allow multiple schema selection so that they don't have to compare their whole database.
  
  If it's a popular enough request, we might consider building a tool that is designed to do compares and syncs from one schema to several.
  
  Thanks for raising the issue with the project saving in this area - I've put it into our bug tracking system and hopefully we'll be able to handle this a bit more gracefully (probably through not allowing our users to select multiple schemas against a single source/target in this way )

  0 · Share on Twitter
• chang Posts: 6

  July 19, 2010 1:35PM

  Thanks for the explanation. From your help dialog window built in the tool, it says that target schemas must be unique. It totally makes sense since you do not want the same target schema changed (if you try to sync it) after other comparisons are done to the same target (make those comparison out-of-date). But for the same source schema (which does not participate in the targets) should be totally fine, just like what you have currently supported. The tool allows:
  A -> B
  C-> D
  Then it should also allow:
  A -> B
  A -> C
  But it may not allow:
  A -> B
  B -> C
  or
  A -> B
  C -> B
  Any sync done in A->B makes B->C or C->B out of date.
  
  Let me know if I misunderstand what the tool tries to do.
  Thanks!

  0 · Share on Twitter
• Alice E Redgate › Posts: 108

  July 20, 2010 8:32AM

  Thanks for your comments.
  
  You've definitely identified one of the reasons why supporting this request is quite difficult Part of the problem lies in identifying which mappings are legitimate and which are not.
  
  Supporting one-to-many compares and syncs is a feature that is often requested for our SQL Compare tool - I've created a feature request for this in Schema Compare so we can track how popular it is with our users.
  
  It's definitely something we'd really like to do, but unfortunately would require a significant amount of rework to the engine.
  
  Thanks,
  
  Alice.

  0 · Share on Twitter