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
- :
- How to execute SQL Scripts in Installscript project
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
‎Feb 08, 2008
02:20 AM
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.
Please help asap as it is urgent....
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.
Please help asap as it is urgent....
(2) Replies
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Feb 08, 2008
07:22 AM
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.
Debbie Landers
Macrovision Corporation
Debbie Landers
Macrovision Corporation
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Feb 09, 2008
06:07 AM
Hi Debbie,
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.
Debbie Landers
Macrovision Corporation
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.
Debbie Landers
Macrovision Corporation
![](/skins/images/7DF1852B2C95702E61A73F170B191DAC/responsive_peak/images/icon_anonymous_message.png)