>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.

We're looking for such tool also. So far we found two of them but didn't decide yet which one we'll use:
- SQL Compare from http://www.red-gate.com/SQL_Compare.htm
- SqlDiff from http://www.apexsql.com/index_sqldiff.htm