Distributing Schema Updates

[markphsd]

Hello,

I have a number of distributions of a database for a Sales application. We want to version each group of changes to the schema by the development team, then package those changes for distribution along with our application distribution updates.

Currently we have to connect to each application using Enterprise Manager and manually apply updates. This is tedious, prone to mistakes and time consuming.

The updates will be performed by the end user. Most users are running MSDE 2000, or will be running SQL Server 2000. So the process should be automated. I.E. - Backup - Perform Schema Change - Report Results.

I have looked at Idera, but they don't have the solution we are looking for: SQL Change manager is charged per instance and beyond the scope of what we are doing.

thank you for any help.

Mark P.

http://www.cafecartel.com

Providing Low Cost Powerful Point of Sale Solutions.

 

[mrdenny]

I would package the T/SQL commands as part of the installer that does the actual upgrade. Have it run the backup, then once the backup is complete have it launch sqlcmd and execute the sql commands in the file.

That is after all how Microsoft does it with there service packs.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com