Check for Multiple SQL Server Versions
Posted: Fri Jan 08, 2016 6:08 am
Hi Guys,
I've nearly finished our installer, but need to perform just a few more tweaks. One of these is to detect whether SQLServer 2008 - 2014 is already installed. If none of these are found then we install SQL Server 2014. I have detection of SQL Server 2014 working (as it came with InstallAware), but I'm wondering how I can modify the script to check for versions of SQL from 2008 - 2014? We need to do this because earlier versions of our product may contain earlier versions of SQL and in those cases we want to leave the existing installation intact.
The script that has generated is:
Many thanks,
Damien
I've nearly finished our installer, but need to perform just a few more tweaks. One of these is to detect whether SQLServer 2008 - 2014 is already installed. If none of these are found then we install SQL Server 2014. I have detection of SQL Server 2014 working (as it came with InstallAware), but I'm wondering how I can modify the script to check for versions of SQL from 2008 - 2014? We need to do this because earlier versions of our product may contain earlier versions of SQL and in those cases we want to leave the existing installation intact.
The script that has generated is:
Code: Select all
~InstallAware Clipboard Data~
~Comment~
~{2C103882-7A70-4B48-A734-4C07620EC50D}~
~~
~End~
~{CA30FFCA-6765-4DFE-BF75-63521810E69C}~
~Terminate Install~
~{C9450190-7A54-4F69-A380-2614A199110A}~
~MessageBox~
~{BEC80722-C90A-4C42-911F-BEF35EFF4B2E}~
~$TITLE$ Setup~
~$TITLE$ requires a 64 bit operating system. Please upgrade your operating system and try again.$NEWLINE$$NEWLINE$$TITLE$ Setup cannot continue.~
~3~
~1~
~~
~Else~
~{02B7C5F9-B0A5-4AE6-9685-D317EFC5F880}~
~Set 64 Bit Mode~
~{A70A2271-C849-442E-A942-6BC674A722EB}~
~TRUE~
~FALSE~
~FALSE~
~End~
~{4B8A1CAF-9FA4-4581-A04D-00509BC69348}~
~Set Variable~
~{001BA1E5-CDBF-4A40-8FDE-B0D73AD8BB5F}~
~MSSQL2014_X64$MYAH$MYAH$FALSE~
~TRUE~
~Else~
~{AB9E7CDF-32D2-484F-8562-21751497A8EB}~
~Set Variable~
~{1BAB57BA-AAF0-4D10-92DB-4AF27A207856}~
~PRELIST$MYAH$MYAH$FALSE~
~$PRELIST$$NEWLINE$Microsoft SQL Server Express 2014 sp1 (x64)~
~Set Variable~
~{071891EA-A976-4726-B846-73073D511005}~
~PREREQ~
~TRUE~
~Set Variable~
~{A571124A-ABCD-4194-BF9A-91F12FBC837C}~
~MSSQL2014_X64$MYAH$MYAH$FALSE~
~FALSE~
~Comment~
~{A3574295-3EE0-4296-9D6A-8657E45BCF31}~
~~
~End~
~{9CB8BB1A-758D-460E-945F-4F2AE37C7BBF}~
~End~
~{0187819E-602B-4437-8F38-5D2D2C23671B}~
~End~
~{678F7C52-4B95-4A12-9FC7-48EFD51ABEB8}~
~End~
~{A5FAD396-B102-4DB9-AEF6-AE131532C882}~
~Terminate Install~
~{100F0053-2D91-4DCC-988C-27194AEB9005}~
~MessageBox~
~{2C5CEE15-33EA-41FF-B780-2AB06D2E33EB}~
~$TITLE$ Setup~
~$TITLE$ requires at least Windows 7 or later. Please upgrade your operating system and try again.$NEWLINE$$NEWLINE$$TITLE$ Setup cannot continue.~
~3~
~1~
~~
~Comment~
~{B9B92434-7857-4822-8EDD-B2AF0E331C73}~
~at least Windows 7 is required~
~Else~
~{0E9A97B3-B871-4BE4-90DD-C3448A360BC6}~
~End~
~{B0BCC090-2627-40E4-9A81-36B5B3BF2FF6}~
~Terminate Install~
~{AA05DF29-69CC-4218-BAAF-DF53A589BEB2}~
~MessageBox~
~{E53A3502-3CBF-4DDF-B75C-1D7EF4399E39}~
~$TITLE$ Setup~
~$TITLE$ requires at least Service Pack 1 or later. Please upgrade your operating system and try again.$NEWLINE$$NEWLINE$$TITLE$ Setup cannot continue.~
~3~
~1~
~~
~If~
~{7BCB6AEA-E7B1-445A-8B02-B3BE80D49FEA}~
~OS_SP~
~0~
~FALSE~
~FALSE~
~Get System Settings~
~{E0152DBC-52AF-4382-9736-7330F6BA4E96}~
~OS_SP~
~27~
~Comment~
~{DBA91F29-E882-4213-9E3D-D90786486CD2}~
~For Win 7, at least Service Pack 1 is required~
~If~
~{D1167F81-69B0-42CD-9672-FAB5444A4137}~
~MSSQL2014_ISSEVEN_X64~
~0~
~TRUE~
~FALSE~
~Else~
~{367F7239-EB54-4BAD-9771-A16B17C13FB7}~
~End~
~{AD3636B6-CA8B-46A1-BBD7-F645DC7F4D34}~
~Terminate Install~
~{B9EF624B-A587-4CA8-92D5-7AAF59613A6B}~
~MessageBox~
~{13E1996D-4E7C-40CB-B3A0-A0B610AAB46B}~
~$TITLE$ Setup~
~$TITLE$ requires at least Service Pack 2 or later. Please upgrade your operating system and try again.$NEWLINE$$NEWLINE$$TITLE$ Setup cannot continue.~
~3~
~1~
~~
~If~
~{671D44E4-40F4-4864-9BFC-BC4A5D9A2866}~
~OS_SP~
~0~
~FALSE~
~FALSE~
~Get System Settings~
~{657A0288-487C-4F69-B9AC-A71C4B910F76}~
~OS_SP~
~28~
~Comment~
~{4D566087-64A2-4C7C-9E40-3089B8365AA6}~
~For Win 2008, at least Service Pack 2 is required~
~If~
~{6E0299AB-E0F5-4095-9EED-C60CAD3B87EA}~
~MSSQL2014_IS2008_X64~
~0~
~TRUE~
~FALSE~
~Else~
~{5079EBEB-5BF5-4E7D-BE67-623341AB139A}~
~End~
~{CD2D9FEC-E926-486B-810E-BFF6812B544F}~
~Terminate Install~
~{85513148-FE6F-477E-9186-73EAAA567AB7}~
~MessageBox~
~{341A599D-CD89-4122-82E1-30D40C27DA0C}~
~$TITLE$ Setup~
~$TITLE$ requires at least Service Pack 1 or later. Please upgrade your operating system and try again.$NEWLINE$$NEWLINE$$TITLE$ Setup cannot continue.~
~3~
~1~
~~
~If~
~{1FD3D75B-488F-4C39-B889-0033D77D2023}~
~OS_SP~
~0~
~FALSE~
~FALSE~
~Get System Settings~
~{A612A3A2-01EB-45DD-B7D7-9451CD39AA51}~
~OS_SP~
~27~
~Comment~
~{0F9F5A96-191A-4C9F-B1CE-FE3BC277D4BB}~
~For Win 2008 R2, at least Service Pack 1 is required~
~If~
~{2C81FCE9-398D-4002-8FD8-51025DA8C74F}~
~MSSQL2014_IS2008R2_X64~
~0~
~TRUE~
~FALSE~
~Comment~
~{E2EFBB80-F0AC-4591-B069-E02F7529888A}~
~~
~Get System Settings~
~{B04272EC-3BE4-4A0F-AE64-7713B56A5252}~
~MSSQL2014_ISSEVEN_X64~
~79~
~Get System Settings~
~{5CC587B5-BD3D-4DB6-A9A6-17FC07D638E2}~
~MSSQL2014_IS2008_X64~
~76~
~Get System Settings~
~{45139D0D-EDFD-4F66-8B5E-91BE413D7BBF}~
~MSSQL2014_IS2008R2_X64~
~81~
~Set Variable~
~{0A735161-60BA-4C35-9CB4-E8253F744027}~
~OS_SP$MYAH$MYAH$FALSE~
~~
~Comment~
~{B5718B2E-45DB-4453-B210-77BB2813C453}~
~~
~If~
~{11F34A5E-62AF-4397-AE7F-05E05B9126F1}~
~MSSQL2014_IS8_X64~
~0~
~FALSE~
~FALSE~
~Get System Settings~
~{95497FEF-0393-4847-BE5D-26DD03DC1DE6}~
~MSSQL2014_IS8_X64~
~87~
~If~
~{A63A485C-33AE-46D8-8BEB-906C3E6F57FD}~
~MSSQL2014_X64~
~0~
~NOTINSTALLED~
~FALSE~
~Check Service~
~{319AC558-3739-4CD6-BC6B-483EE9ECDC73}~
~MSSQL$SQLEXPRESS~
~~
~MSSQL2014_X64~
~Set 64 Bit Mode~
~{40356EAA-1C28-415C-962C-0026ABD29BEB}~
~FALSE~
~FALSE~
~TRUE~
~If~
~{FB55876B-8245-4239-96E8-B2B77457821D}~
~ISWINDOWS64BIT~
~0~
~TRUE~
~FALSE~
~Get System Settings~
~{9B1B333F-A72A-4FCE-85A3-9F2E1F0F8FBB}~
~ISWINDOWS64BIT~
~65~
~Set Variable~
~{292AB0F7-607C-413B-A4FB-AF133E0F7ED1}~
~ISWINDOWS64BIT$MYAH$MYAH$FALSE~
~FALSE~
Many thanks,
Damien
