This website uses cookies. By clicking Accept, you consent to the use of cookies. Click Here to learn more about how we use cookies.
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
- Revenera Community
- :
- InstallShield
- :
- InstallShield Forum
- :
- Installing SQL Server 2008 R2 as Install OR Upgrade
Subscribe
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
Sep 07, 2010
11:01 AM
Installing SQL Server 2008 R2 as Install OR Upgrade
I have an application that we have been distributing with SQL Server 2008 and we would now like to upgrade our users to SQL Server 2008 R2. I would like the same installation program to be run by old users (who will be upgrading) and new users (who will just get a full install of R2).
The problem is that in the SQL Server 2008 R2 Redistributable, I must specify either "/ACTION="Install" OR "/ACTION="Upgrade".
I would like the SQL Server 2008 R2 Command line parameters to be different depending upon if a prior version of my SQL Server instance is already installed or not.
I can't see any way to make the command line conditional. Alternatively, I had hoped to be able to create a copy of the SQL Server 2008 R2 Redistributable (one for a full install and one for an upgrade) but I couldn't see a way to do that either.
Any ideas?
The problem is that in the SQL Server 2008 R2 Redistributable, I must specify either "/ACTION="Install" OR "/ACTION="Upgrade".
I would like the SQL Server 2008 R2 Command line parameters to be different depending upon if a prior version of my SQL Server instance is already installed or not.
I can't see any way to make the command line conditional. Alternatively, I had hoped to be able to create a copy of the SQL Server 2008 R2 Redistributable (one for a full install and one for an upgrade) but I couldn't see a way to do that either.
Any ideas?
(1) Reply
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
Sep 07, 2010
05:39 PM
I solved my problem by duplicating the .prq file and renaming it. Then I had 2 copies that I could conditionally include or exclude as redistributables. Since they are set to download from the web, it didn't really add any extra size to my installation.
![](/skins/images/8CE4FAD0DE6F3A6F9D0567434D2D2DAE/responsive_peak/images/icon_anonymous_message.png)