> I've looked on many different tools that microsoft has to offer in
> MSSQL, but i could not find the one that will do the following for me:
>
> 1 - the production database was set up 6 months ago, on the production
> server...
>
> 2 - the development database was set up the same time, had the same
> structure as the production database... but, I continued to work on
> improving the software, and right now, the development database has
> much more improved structure....
>
> 3 - Now, I want to upgrade the production server so that it matches
> the development server in structure... and then I will be able to
> release our new version of the software...
>
> Question: How can i compare my dev to my prod. so that i find out the
> difference instructure, and therefore automatically generate an
> upgrade script that will alter my prod. server to match the dev
> server...
>
> the data does not need to be changed on the production server...

"Tascien" <tascienu@ecoaches.com> wrote in message
news:80e33136.0403281037.4af1a994@posting.google.com...
> I've looked on many different tools that microsoft has to offer in
> MSSQL, but i could not find the one that will do the following for me:
>
> 1 - the production database was set up 6 months ago, on the production
> server...
>
> 2 - the development database was set up the same time, had the same
> structure as the production database... but, I continued to work on
> improving the software, and right now, the development database has
> much more improved structure....
>
> 3 - Now, I want to upgrade the production server so that it matches
> the development server in structure... and then I will be able to
> release our new version of the software...
>
> Question: How can i compare my dev to my prod. so that i find out the
> difference instructure, and therefore automatically generate an
> upgrade script that will alter my prod. server to match the dev
> server...
>
> the data does not need to be changed on the production server...
>
> Thanks for your response in advance...