>>>>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
>>
>>Regarding RedGate. It does not have to be installed on the customer server, does it? Only on your (developer's) computer?
>>
>>And I will check the thread you references. Thank you.
>
>Yes, you install it on your development server. You need to keep one version of the database which is the current version and one which is development. Once you ready to sync them, you run that tool and it generates the changes script which you then give to the customer to run. And then that version of the database becomes the current version.

I was hoping that I would not have to keep a copy of each customer database in my system, for comparison. Thank you.