Re: database scheme upgrade problem

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Farmer (someone_at_somewhere.com)
Date: 09/25/04 

Date: Fri, 24 Sep 2004 23:43:27 -0500

I use ApexSQL Diff for that.

"Hari Prasad" <hari_prasad_k@hotmail.com> wrote in message
news:%23Ssc0hroEHA.516@TK2MSFTNGP09.phx.gbl...
> Hi,
>
> Using the 3rd party tool "SQLCompare" to do a DDL comparison bettwen
> clients database and new database. After that prepare a script
> and send it to clents place. SQLCompare itself have the feature to
> generate the script to get the changes.
>
> Download the tool from below site:
> http://www.red-gate.com/sql/summary.htm
>
> Thanks
> Hari
> MCDBA
>
>
>
> "angus" <angus@angus.com> wrote in message
> news:eOk7LxqoEHA.2588@TK2MSFTNGP12.phx.gbl...
>> Dear All,
>>
>> i am a software developer using mssql.
>>
>> There was a database A was used to development my system and it was
>> deployed
>> to
>> the client.
>>
>> then, in the past months, the client wanted to add a lot of functions. I
>> changed the database scheme
>> (add new fields in the current table in database A; modify the column
>> scheme........etc)
>>
>> now, the problem is, i have forgotten what i have modified. and i have to
>> upgrade the database to
>> the client without ruinning the data of client.
>>
>> How can i do it? besides buying other software for that purpose.
>>
>> Thank you
>>
>> Regards,
>> Harry
>>
>>
>
>

Relevant Pages