>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.
____________________________________
Don't Tread on Me
Overthrow the federal government NOW!
____________________________________