How to build a specialized installer in VS2010?

I'm looking to build a specialized msi installer, preferably with VS2010 to do the following:

  1. Be able to configure SQL server connection.

  2. Pick the database to be used from the SQl server.

  3. Create database table with specified credentials.

  4. Assign a new DB user a set of permissions.

  5. Also configure the IIS application.

I looked into a default installer project in VS2010 and it has nothing related to dealing with SQL server and IIS. Any idea how can I do all this?

Answers


Visual Studio setup projects do not offer support for SQL scripts and IIS. The best you can do is write some custom actions (using custom code) to handle this during install.

Commercial setup authoring tools offer the most control over SQL scripts and IIS elements. You can find a list here: http://en.wikipedia.org/wiki/List_of_installation_software

You can also try WiX. It has a steep learning curve, but it's free and gets the job done.


Need Your Help

How to display only end result in while loop PHP?

php loops while-loop once

I have a problem that I do not know how to solve. See the below while loop:

How to test whether a class instance is a dynamic type in AS3?

actionscript-3 flash properties dynamic-class

In AS3, if a class is marked as dynamic, new properties can be added and removed at runtime, by simply setting the property or removing it with the delete keyword.

About UNIX Resources Network

Original, collect and organize Developers related documents, information and materials, contains jQuery, Html, CSS, MySQL, .NET, ASP.NET, SQL, objective-c, iPhone, Ruby on Rails, C, SQL Server, Ruby, Arrays, Regex, ASP.NET MVC, WPF, XML, Ajax, DataBase, and so on.