>>>>>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.
>>>
>>>The structural copy, not the copy of their database. Assuming all customers are running with the same structure.
>>
>>Not in my case. The approach that you suggested is better than what I do now, however.
>
>For now you can also probably go with the free tools (Red Gate may be expensive). I believe in that thread I referenced another thread which in turns provides a link to a free solution.
I am looking at the page of Apex SQL Diff to see if this approach will be easier to implement.
"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
