Creating views with dependencies

• 
  I've run into this problem as well. Whenever it happens, I just de-select the view with the dependent view and re-synchronize that view in afterwards.
  
  I do agree that this is quite an annoyance and would love to know a better solution.

  Curtis Yiu June 16, 2005 15:58

  - 0 +
• 
  I suppose that's doable, but very annoying when there is a lot of views that need to be picked through line-by-line. Thanks, though!

  bmilne June 17, 2005 07:40

  - 0 +
• 
  Yeah, you'd think that since Enterprise Manager has the ability to map object dependency trees (kind of), the guys from Red-Gate would have thought it a necessary feature.

  Pork Pants June 17, 2005 07:46

  - 0 +
• 
  Hello,
  
  I'd think it would be pretty unusual if this didn't work. SQL Compare has a very sophistocated text parsing engine that builds the dependency list so that all dependent objects are scripted as part of the migration. Enterprise Manager uses the (notoriously unreliable) sysdepends table that breaks if object dependencies are rearranged after creation.
  
  I'd make sure that you have the 'include dependent objects' option on as the default dependency behavior can be changed with this option set in the comparison options.
  
  As usual, if you've got any scripts that you can send with examples of dependency chains that break SQL Compare, they're always welcome at our support department. (support at red-gate.com)

  Brian Donahue June 20, 2005 09:25

  - 0 +
• 
  I'll try to submit one. I had to uncheck that box because then it was trying to copy over the user accounts and since they already existed on the other server it would error out at that point.

  bmilne June 20, 2005 09:33

  - 0 +

Add comment

Please sign in to leave a comment.