I got a web setup project deploying a web appllication and couple of SQL scripts to be executed against an SQL Server database (creating user database, tables, procedures, etc.).
I intend to create an upgrade for this website. This is what I did: 1. Update the files to be installed. 2. In the General Information > Product Properties view, increase the version number. 3. Build project. 4. Run the setup.exe, and a message box will appear telling that it will do an upgrade. 5. Click OK, and the new files will be copied to installation folder immediately.
My question is, how can I prompt the user after clicking the OK button to ask them whether they want to upgrade the database (using a script that only executes during Upgrade)? After I click OK, it immediately starts the Upgrade.
Say that I have 5 scripts (script1.sql to script5.sql). Script 1 to 4 will be executed during install but script5.sql will be executed ONLY during Upgrade, and I need to ask the user first before executing script5.
