>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.
Aside from VS2010 Premium, I'll second Naomi's suggestion of SQL Compare from
www.red-gate.com. That is what I used for a few years until I got VS2010 Premium. They do have a 14 day trial.
____________________________________
Don't Tread on Me
Overthrow the federal government NOW!
____________________________________