We have a project with several applications including web applications, web services, windows services and windows applications. We also have prerequisites like SQL Server Express, .NET 2.0 and others. We don't have much user interaction during the setup but we want to add more intelligence to it.
We are currently using Visual Studio to generate the integrated setup for all this. But we continuously struggle with it to make it work like we want.
We want to change our setup tool into something simpler and flexible enough.
We are also looking for a better solution for the upgrader, that must run upgrade sql scripts on the deployed system. Maybe this could be integrated with the setup.
We are thinking about using InstallShield, but some say that it brings a lot of complexity. What do you think is the best tool for this job?
Thanks!