How to execute SQL Scripts in Installscript project
Hi
I am a newbie using installshield professional 2008.I have created a Installscript project and i need to know how to execute SQL scripts I have a batch file which in turn will call SQL scripts. What are the steps or any sample code available for doing the same. I am using SQL Express 2005 SP2.
In the View List under Server Configuration, click SQL Scripts. In this SQL Scripts view, you'll want to add and configure a SQL connection. Then you can add your SQL script under your SQL connection. For how-to information, see the "Configuring SQL Support" section in the InstallShield Help Library. That'll hopefully help you get started.
thanks for your prompt reply. My problem is actually we are calling an SQL script through batch file.... it executes the batch file but the SQL scripts are not being executed. so i am not sure how to go about it. I am using SQL Express Edition SP2 with windows vista
QUOTE=DebbieL;407627]In the View List under Server Configuration, click SQL Scripts. In this SQL Scripts view, you'll want to add and configure a SQL connection. Then you can add your SQL script under your SQL connection. For how-to information, see the "Configuring SQL Support" section in the InstallShield Help Library. That'll hopefully help you get started.
