Re: database scheme upgrade problem

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

From: Hari Prasad (hari_prasad_k_at_hotmail.com)
Date: 09/25/04 

Date: Fri, 24 Sep 2004 23:31:46 -0500

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