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
- :
- Runing an external SQL script during the installation?
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
May 13, 2008
05:39 AM
Runing an external SQL script during the installation?
Hello Guys,
I was just wondering if there's a way to execute an SQL script (it contains some insert statements) that is on the installation media but not part of the setup executable. What I'm trying to do is to build the install project once and include an SQL script in the CD together with the installer. Each client can potentially have different content for this script, and I like the installer to locate this file at a particular location (for example, the file is called "custom.sql" located in the same place as setup.exe).
From the Installation Designer under SQL scripts, if I choose "Insert script files..." or "Import script files", the content will be static. Is Installshield 2008 capable of doing this or is there a workaround?
PS: The project type is Web Project.
Thanks,
I was just wondering if there's a way to execute an SQL script (it contains some insert statements) that is on the installation media but not part of the setup executable. What I'm trying to do is to build the install project once and include an SQL script in the CD together with the installer. Each client can potentially have different content for this script, and I like the installer to locate this file at a particular location (for example, the file is called "custom.sql" located in the same place as setup.exe).
From the Installation Designer under SQL scripts, if I choose "Insert script files..." or "Import script files", the content will be static. Is Installshield 2008 capable of doing this or is there a workaround?
PS: The project type is Web Project.
Thanks,
(1) Reply
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
May 13, 2008
06:04 AM
One workaround that I can think of right now is to:
1. Create a dummy script in the Installation Designer and the script will contain only a placeholder for text replacement.
2. Configure the Text Replacement to replace that placeholder with an installer property.
3. Create a custom action that, during the installation, reads the content of the "extra\custom.sql" and store it in that installer property.
But i'm afraid the content of custom.sql might be too large for an installer property to hold.
1. Create a dummy script in the Installation Designer and the script will contain only a placeholder for text replacement.
2. Configure the Text Replacement to replace that placeholder with an installer property.
3. Create a custom action that, during the installation, reads the content of the "extra\custom.sql" and store it in that installer property.
But i'm afraid the content of custom.sql might be too large for an installer property to hold.
![](/skins/images/8C9D13A71C7F7695F3262372C0172D68/responsive_peak/images/icon_anonymous_message.png)