SQLServer2008R2 in 32bit/64bit mode

[anja_laenge]

Hi,

I have a working setup that makes a custom installation for sql2008r2 and all the servers and applications prerequiites for 32bit machines. I need to add functionality to do the same for 64bit machines.

The current prerequisites are these:
- Microsoft .NET Framework 2.0 with Service Pack 2
- Microsoft .NET Framework 3.0 with Service Pack 2
- Microsoft .NET Framework 3
- Microsoft .NET Framework 3.5 with Service Pack 1
- Microsoft .NET Framework Client 4
- Microsoft Internet Explorer 6 with Service Pack 1
- Microsoft MDAC Refresh 2.8
- Microsoft Windows Installer 3.1
- Microsoft Windows Installer 4.5
- Microsoft XML Parser 6.0

What would be the best way (and that with least changes) to do this?
Checking 64bit mode and calling prerequisites check/setup scripts in an if/else clause?
Regarding the sql2008r2 installation whichtakes place at a later step during installation, would be the same applyable here? Checking 64bit mode, setting 64bit installation mode if so, choosing the corresponding filebag and proceed as before?

Thanks in advance!

[FrancescoT]

Dear User,

It is enough to execute only the checking of the required runtimes conditionally (x86 or x64).

For example, at runtimes verification could be:

Code: Select all

Set Variable ISWIN64 to FALSE
Get System Setting Windows in 64 bit Mode into ISWIN64
 
if Variable ISWIN64 Equals TRUE
  Include Script: checknet20sp2_x64
  Include Script: checkmsxml60_x64
  Include Script: checknet30_x64
  Include Script: checknet30sp2_x64
  Include Script: checknet35sp1_x64
  Include Script: checksql2008r2_x64
  Include Script: checkmsi45_x64
 else
  Include Script: checknet2sp2
  Include Script: checkmsxml60
  Include Script: checknet30
  Include Script: checknet3sp2
  Include Script: checknet351
  Include Script: checksql2008r2_x86
  Include Script: checkmsi45
end


It is not necessary to follow a specific order for "checking runtime scripts" execution, on the contrary at runtime installation scripts, it is important to follow the correct installation order.

For example, if your projects uses the runtimes as above, this should be;

Code: Select all

if Variable ISWIN64 Equals TRUE
  Include Script: setupmsi45_x64
  Include Script: setupnet20sp2_x64
  Include Script: setupmsxml60_x64
  Include Script: setupnet30_x64
  Include Script: setupnet30sp2_x64
  Include Script: setupnet35sp1_x64
  Include Script: setupsql2008r2_x64
else
  Include Script: setupmsi45
  Include Script: setupnet2sp2
  Include Script: setupmsxml60
  Include Script: setupnet30
  Include Script: setupnet3sp2
  Include Script: setupnet351
  Include Script: setupsql2008r2_x86
end


At runtimes installation it is not forcedly required to include the installation runtime scripts conditionally, because the installation will be indeed executed only if check process validates it. If for your convienience you prefer to include the installation runtime scripts conditionally (as above)... it is up to you.

Hope this helps you.

[anja_laenge]

Okay. Thank you!