>I am converting a VFP application to a SQL Server back end. I am pretty new to SQL Server. As I send upgrades to our end-users, is there a utility to help update their SQL table structures as I make changes? Is there a good reference or source I can read on best practices for this?


You can script your changes (all the changes that you make visually to your database can be done in code).

Or you can use a tool that will do it for you. Take xcase for example (xcase.com): it will keep your data model separate from your sql server. Make your changes to your xCase model, then synchronize it with your SQL server database. It works really well.

José