Generating upgrade scripts

[James Berry]

Hi,

I have an application that is to be deployed at a number of sites. That's
no problem: I can generate the schema from my development database and
install it at each site. The problem comes with upgrades - is there an
automatic way, or a tool, to generate scripts that can be used to upgrade
all the tables in a database (which has got constraints etc) to the new
layout (as per my development machine).

Generally, the only changes would be addition of fields, I'm certainly not
expecting it to do any rocket science!

Best wishes
James

[DaveSatz]

You can either write the code yourself to do the upgrade or look at:

http://www.red-gate.com/sql_tools.htm
http://www.embarcadero.com/products/...mdatasheet.htm
http://www.aloeco.com/upgrader/

see http://www.mssqlserver.com/products/ for more
--

HTH,
David Satz
Principal Software Engineer
Hyperion Solutions
{ SQL Server 2000 SP1/7.0 SP3/6.5 SP5a } { Cold Fusion 5/4.5.1 SP2 } { VSS }
(Please reply to group only - emails answered rarely)
This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use.
-----------------------------------------------------------------

"James Berry" <james@adastra.co.uk> wrote in message
news:3bb993eb@news.devx.com...
> Hi,
>
> I have an application that is to be deployed at a number of sites. That's
> no problem: I can generate the schema from my development database and
> install it at each site. The problem comes with upgrades - is there an
> automatic way, or a tool, to generate scripts that can be used to upgrade
> all the tables in a database (which has got constraints etc) to the new
> layout (as per my development machine).
>
> Generally, the only changes would be addition of fields, I'm certainly not
> expecting it to do any rocket science!
>
> Best wishes
> James
>
>
>