What are the challenges you face when working across database platforms? Take the survey
Options

SQL Compare and unrefreshed Views

chuckredgatechuckredgate Posts: 6 Bronze 1
edited July 2, 2021 8:24AM in SQL Compare
If you make a change to a SQL table that is being used in a view, such as a field length change, and you do not refresh the View the view will still have the old field length in it.  If I have a View that has been refreshed on one server, but not refreshed on the other server SQL Compare does not seem to be able to detect this difference.

Is there anyway to get SQL Compare to detect the difference between a refreshed View and a non-refreshed View?
Tagged:
Sign In or Register to comment.