Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
>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.
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement