General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>How do you add a new View to an application that's already been distributed, installed, and in production? I've got a database container organizing the data in my app but need to introduce a collection of new views. Is it a simple matter of redistributing an updated container? One that has the new view definitions? Any other "gotchas" to be aware of?
>
>I thank you in advance for your input, ideas, thoughts and advice.
Download Erik Moore's GenView from the files section. What you do is open up your view in the test enivronment then run GenView, this creates a script that you run in your live environment that recreates the view.
Don't copy database containers around, this causes all sorts of problems with the links to the tables.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only