I have created an InstallShield installer where it has a dependency on a SQL Server 2008 Express R2. I am trying to add a reference to this redistributable but it does not appear in the list of redistributable packages.
This will be installed on 32 and 64 bit platforms.
I am using VS 2010 with InstallShield 2011 LE (Limited Edition).
I would like to avoid including the SQL Server setup MSI in my installer, because including 32 and 64 bit versions of SQL Server will cause the size of the install to be too large and will be unnecessary if the target computer already has these installed.
I would like the correct version to be installed, depending on the platform. I.e. 64 bit SQL Server on 64 bit machines, and 32 bit SQL Server on 32 bit machines.
Looking through the Redistributables section in my installer there is an option for SQL Server SP1, but no option for SQL Server R2, and I cannot see anywhere to add other installs.
What is the recommended way of including this prerequisite? Is there some kind of bootstrapper I need to add to my project. I would like to avoid having to add any custom script/code if possible and keep the installer simple.
Thanks in advance!