I have a legacy database server with a lot of views installed without schema-binding. Over time, these views have fallen into disrepair and some refer to objects that no longer exist, or to columns whose names have changed.
In order to test an upgrade script, I would like to install the schema objects onto an empty test database. However, many of the views cannot be loaded because they are in a state of disrepair.
Is it possible to get SQL Server to load views that refer to non-existent objects in order that I can test my repair scripts ?
I can do this using backup and restore, but I do not want to load the data-set which is large and takes hours to load.