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
- :
- Silent Installation of SQL Server
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
Jan 14, 2013
04:39 AM
Silent Installation of SQL Server
Hi All,
I'm still considering whether to buy installshield for my company. I have yet to see if I can install sql silently and correctly, this task is very important for me.
I must build a cd-rom installation and I want install sql silently using a configuration file.
Before install sql I must:
- verify if other sql instance exist
- if other sql instance exist, change my configuration file with a correct istance name. Save this configuration file in the temp folder of the destination computer.
What is the best way for me? I thought of two possibilities:
1. using custom action to verify sql instance, modify the configuration file and save it in a temp folder. Then I can install sql by command promt using new configuration file
2. using feature and before of this a custom action
Point 2 seems to me more correct but to do that I should:
- execute a custom action before feature (to modify the configuration file and save it in a temp folder). I don't understand how I can do this.
- insert temp folder location in the command line of prerequisite of my features. But my problem is that in the prerequisite editor doesn't exist a folder property which refers to the temp folder (such as ISPREREQDIR for example).
Can someone help me?
Thanks in advance
I'm still considering whether to buy installshield for my company. I have yet to see if I can install sql silently and correctly, this task is very important for me.
I must build a cd-rom installation and I want install sql silently using a configuration file.
Before install sql I must:
- verify if other sql instance exist
- if other sql instance exist, change my configuration file with a correct istance name. Save this configuration file in the temp folder of the destination computer.
What is the best way for me? I thought of two possibilities:
1. using custom action to verify sql instance, modify the configuration file and save it in a temp folder. Then I can install sql by command promt using new configuration file
2. using feature and before of this a custom action
Point 2 seems to me more correct but to do that I should:
- execute a custom action before feature (to modify the configuration file and save it in a temp folder). I don't understand how I can do this.
- insert temp folder location in the command line of prerequisite of my features. But my problem is that in the prerequisite editor doesn't exist a folder property which refers to the temp folder (such as ISPREREQDIR for example).
Can someone help me?
Thanks in advance
(1) Reply
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
Jan 25, 2013
05:25 AM
you can install SQL(Express) silently via a configfile, we already do it for many years.
You define in the configfile the non-variable properties for the installation and you pass the variable properties on the commandline.
Commandline looks like this for example:
Sprintf(
strOptions,
"/Q /INDICATEPROGRESS /ConfigurationFile=\"%s\" /SAPWD=%s /INSTANCEDIR=\"%s\" /INSTALLSQLDATADIR=\"%s\" ",
SetupGetProperty("SUPPORTDIR") ^ "SQLExpress_2008.ini",
GetSQLPassword(),
RemoveLastFolderSlash(strProgram),
RemoveLastFolderSlash(strData));
You define in the configfile the non-variable properties for the installation and you pass the variable properties on the commandline.
Commandline looks like this for example:
Sprintf(
strOptions,
"/Q /INDICATEPROGRESS /ConfigurationFile=\"%s\" /SAPWD=%s /INSTANCEDIR=\"%s\" /INSTALLSQLDATADIR=\"%s\" ",
SetupGetProperty("SUPPORTDIR") ^ "SQLExpress_2008.ini",
GetSQLPassword(),
RemoveLastFolderSlash(strProgram),
RemoveLastFolderSlash(strData));
![](/skins/images/D60DF682EA37BF37032955CE10F3F0BB/responsive_peak/images/icon_anonymous_message.png)