Does anyone know of any resources or guidance on creating upgrades for web applications?  I'm having problems getting the behavior I want out of my msi.

At first patches seem like a good way to go, however I need to execute a sql script against the application's database and it seems that isn't possible with a patch.

I need to supress all of the dialogs except for the sql connection dialog for upgrades and I need to make sure that the web.config file does not get replaced.

Any help would be appreciated.

-Kevin