How do I copy a SQL view? My client is upgrading one of the entry products. The main database has to stay constant and continue to feed the first point of entry product...thank you in advance. This is not copying a view from one database to another. I want to edit the view for the upgraded version. Lab
How will your database know which version of the product is calling it? It seems you will have to either copy the view to a new name (right click in object explorer, script, as create, to new window, change the name then run), or in some other way identify which version of the product is calling. This does however point to a general issue of backwards compatibility not being fully thought through - there are a number of other issues that can occur, and may only become apparent upon testing; I'd suggest you ensure that this testing is carried out before resolving just one view.