I am interested in knowing what the best software would be to build an installation package that performs the following:
(1) Installs client application
(2) Detects all SQL server instances on network, allowing user to select specific database to upgrade (which would then upgrade database using an embedded SQL script)
(3) Installs website on a server/location specified by user, and configures IIS 6.0 and/or 7.0 based on settings that I specify.
(4) Creates a simple setup.exe - and allows user to choose installation components (listed above, i.e install client app, sql server database, and/or website), and then download selected components from remove server.
I have tried NSIS - as was able to create an installation package that will download a compressed (gzip) component from a remote server, decompress the file, install the components, and then remove the gzip file. So, this worked beautifully. The part where I am stuck is to be able to perform the database upgrade and website install.
Any suggestions would be great.
Thanks.
Chris