Calling SQL Script and setting element content in XML files Conditionally in InstallShield 2008 Premier Edtion
Posted on 2009-04-17
We have created a installer project with SQL Express as prerequisite.We have made it optional so that user can skip it. We have included certain SQL Scripts files which automatically creates database whenever product is installed. As SQL Express is made optional, user can skip it.so, what we want is whenever user skips SQL Express installation, we do not want that SQL Script get executed.I mean we do not want to create database.So, my question is can SQL script be executed conditionally?
Another probelm we have is setting element content in XML file. we create a xml file to store connectionstring which is later used to connect to SQL server database. As SQL Server has 2 authentication modes-Windows and SQL server, connectionstring would be different for both modes.For windows mode connectionstring would be like
and for SQL Server mode, it would be like
server=(Local)\SQLEXPRESS;user id=sa;password=sa123;Initial Catalog=ESCtSample;
so, can we set element content conditionally in xml file?
Thanks in advance