Forum for users of SQL Compare schema synchronization utility


Postby anna.p » Fri Aug 23, 2013 1:05 am


We have a lot of views with SCHEMABINDING.

It often happens that SQL Compare will miss a dependency and attempt to alter a table referenced by a schema bound view without first altering the view to remove the SCHEMABINDING.

This doesn't happen all the time; I'd say 70% of the dependencies are caught and 30% aren't.

How does SQL Compare determine when a view needs to be altered to remove SCHEMABINDING? Is there some system table it checks? If so, maybe we have inconsistencies in that system table?

It's getting a little frustrating having to add 2 ALTER VIEW statements manually to a bunch of build scripts... :-/

I'm normally using the GUI, by the way.
Any ideas would be appreciated!
Posts: 23
Joined: Tue Jul 03, 2012 9:59 pm

Return to SQL Compare Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests