Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
SQL maintenance questions
I am just delving into the possiblity of using SQL server and have some questions on the feasibility.
We have a vertical market applications, and would like to support both a SQL and VFP back-end. I have been informed in the past that it would be a lot easier to abandon the VFP tables altogether, and simply support SQL, instead of supporting both. Generally, how daunting is it to support both? Are there issues that I should be aware of that may make it impossible or entirely impractical?
Also, I am concerned with support. We currently release periodic updates to our clients that contain an empty set of all tables and databases (something of a data-dictionary). This is used to add and update the existing customers tables to match our current srtucture. I would like to similarly update the SQL table configuration from an update. With the security aspects of SQL, I am not sure what problems I may run into. Is it possible to reconfigure SQL tables programatically in this manner? I'm sure it must be, but I haven't found any documentation on this subject.
Thanks,
David
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