>>>Hi,
>>>
>>>I am getting tired updating my customers with changes I do to the SQL Server table structure and constraints. So I am willing to invest in a tool that will help me.
>>>
>>>What I am looking for (if it exist) is a tool that I can run on my PC (and that will work with either SQL 2005 or SQL 2008), then create some kind of script that I can run in the SSMS of the custom database and update their database to match mine. What would you recommend? Thank you in advance for any suggestion.
>>
>>If you have VS2010 premium it has very good tools for schema and data comparison and synchronization. I've been extremely happy with it.
>
>No, I don't have VS 2010. Do you know if this tool is part of the Express (free) version of VS 2010 or only Professional?
>Thank you.

Premium. It is the next step above Professional. It's not cheap :(