How to create msi project for more than 1 projects

it is very easy to make a msi project for any single project .. but my question is that, i want to make a msi project that contains 2 Existing Project and 1 SQL SERVER Setup within it.

i want to install SQL SERVER from msi then install 2 exe .. Please give me any suggestion or reference .

Thank You

DONT DO IT. Point. Installing SQL Server rom within an MSI is not supported for the obvious problem of updating it.

You should divide the problem to:

1. Installing the prerequisites.

   You'll have to use a Bootstrapper to initiate Microsoft SQL Server's installer before starting your own MSI package. For example, take a look at dotnetinstaller project.

2. Installing your application.

   To merge more than one project in a single installer, check the following question: How to deploy multiple projects in a single MSI?