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

We're using RedGate SQL Compare tool.

See also this thread Compare SQL Tools Thread #1419284