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
- :
- Re: Patch sql scripts
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
‎Sep 09, 2010
04:50 PM
Patch sql scripts
Hello,
I am designing patch for our installer. I know there will be sql scripts to run during the patch install to patch our product's database. To do that, I made my base installer to run some sql scripts using SQL Scripts view of InstallShield IDE and have a runtime condition "PATCH".
Now I made a quickpatch project to patch those sql files and installed the patch. Although the sql files were patched, but it seemed that the old copies of those file were executed. How can I execute the new patched sql files during patch install? If SQL Script view does not support it, what is the best way to make patch installer executing some sql files that are part of the patch package?
Thanks.
I am designing patch for our installer. I know there will be sql scripts to run during the patch install to patch our product's database. To do that, I made my base installer to run some sql scripts using SQL Scripts view of InstallShield IDE and have a runtime condition "PATCH".
Now I made a quickpatch project to patch those sql files and installed the patch. Although the sql files were patched, but it seemed that the old copies of those file were executed. How can I execute the new patched sql files during patch install? If SQL Script view does not support it, what is the best way to make patch installer executing some sql files that are part of the patch package?
Thanks.
(4) Replies
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Sep 10, 2010
10:43 AM
Hi,
I am sure I read somewhere that you need to increment the revision number for the sql script from installshield sql script view.
Vijay
I am sure I read somewhere that you need to increment the revision number for the sql script from installshield sql script view.
Vijay
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Sep 10, 2010
12:45 PM
Thanks for your reply.
But if I do not specify a schema version number for a SQL script, the script is always launched, according to InstallShield Help.
What I found out is that I cannot execute a sql script that is installed by the installer as 'SQL Script File Name' field of SQL Scripts view doesn't allow entry like [INSTALLDIR]MySqlFile.sql (error message: Invalid file name entered.). This does not make sense to me.
How to execute a sql script that is installed by the installer during install using InstallShield?
But if I do not specify a schema version number for a SQL script, the script is always launched, according to InstallShield Help.
What I found out is that I cannot execute a sql script that is installed by the installer as 'SQL Script File Name' field of SQL Scripts view doesn't allow entry like [INSTALLDIR]MySqlFile.sql (error message: Invalid file name entered.). This does not make sense to me.
How to execute a sql script that is installed by the installer during install using InstallShield?
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Oct 08, 2010
07:21 AM
Hi ,
I have a SQL Script named "output.sql" which has command to create a table.
I have to run this during isntallation. How do i do??
I am new to install Shield
I have a SQL Script named "output.sql" which has command to create a table.
I have to run this during isntallation. How do i do??
I am new to install Shield
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Oct 08, 2010
08:08 AM
Hi JasperAJPrabhu,
I am not sure whether this is a efficient way of doing but I usually do this to run a sql script. Launch SQLCMD using LaunchAppAndWait() and pass the necessary parameters like " -S .\SQLEXPRESS -d '' -Q "Query". If any body has an efficient way than this please advice
I am not sure whether this is a efficient way of doing but I usually do this to run a sql script. Launch SQLCMD using LaunchAppAndWait() and pass the necessary parameters like " -S .\SQLEXPRESS -d '
![](/skins/images/8C9D13A71C7F7695F3262372C0172D68/responsive_peak/images/icon_anonymous_message.png)