This website uses cookies. By clicking Accept, you consent to the use of cookies. Click Here to learn more about how we use cookies.
Accept
Reject
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
MichaelJHayes
Level 3
‎Mar 19, 2012 11:18 AM

Need to switch between sql scripts (sql server & oracle) based on property

The web applications I am installing can run against either a SQL Server or Oracle database. I need to be able to determine which database the user has and then dynamically tell InstallShield what SQLscript to run, I know I can figure out how to determine which database is installed. My question is how do I configure the Feature/Component and tell InstallShield which script to use.
Labels (1)
Labels
0 Kudos
(1) Reply
MichaelJHayes
Level 3
‎Mar 19, 2012 04:37 PM

Within a Custom Action I was able to read a config file using FileGrep() to see if it had the Connection setting for MS SQL Server. If it did I set a property to 1, otherwise I set it to 0. Under Server Configuration I added two files under my SQL Connection. Under each file I added a "Conditional Statement" that checked the property I updated in the Custom Action. This way only one SQL script will fire.
0 Kudos