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?
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?
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 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
