>>Hi,
>>
>>How do you update a database structure (default keys, constraint, etc) installed on the customer site with the changes you have made to your copy of SQL Server database? That is, I understand that I have to create some script and send it to the customer and instruct them to run this script, correct? How do you create such a script? TIA.
>
>There is always ALTER TABLE. (In a script, as Bruce says).
As Sergey said that not all changes can be done with the ALTER TABLE. And I am sure sooner or later I will run into such a situation. Then I will have to find another way of synchronizing mine and the customer's databases.
"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