>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
If it's not broken, fix it until it is.
My Blog