>Can anyone suggest what is the best way to update a deployed database. I beleieved in VFP one can use a tool like Xcase and have the program sent to those deployed, run it and update whatever changes is made in the database. Thanks.
SQL updates are normally done via scripts. If you have a copy of the database as it exists at the other site, xCase can create a script (by comparing the data model to the database) that you can use to update with. Someone at the remote site would need to trigger the script. I imagine most other tools work the same way.
As far as a program that would handle the change, you could write one yourself, but I would be leary of running change script automatically. There is no substitute for a pair of eyeballs watching for problems when the script runs.
Dan LeClair
www.cyberwombat.comSET RANT ON - The Wombat BlogLife isn’t a morality contest and purity makes a poor shield. - J. Peter MulhernDisclaimer: The comments made here are only my OPINIONS on various aspects of VFP, SQL Server, VS.NET, systems development, or life in general, and my OPINIONS should not be construed to be the authoritative word on any subject. No warranties or degrees of veracity are expressed or implied. Void where prohibited. Side effects may included dizziness, spontaneous combustion, or unexplainable cravings for dark beer. Wash with like colors only, serve immediately for best flavor.
