>>>>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.
>>
>>No, I don't have VS 2010. Do you know if this tool is part of the Express (free) version of VS 2010 or only Professional?
>>Thank you.
>
>Premium. It is the next step above Professional. It's not cheap :(
But I am :)
"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