>>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 #
1419284Regarding 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.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham