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
- :
- Run SQL Script against all Schema Versions
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
‎May 26, 2008
10:54 AM
Run SQL Script against all Schema Versions
I have an Installscript Project and am using the Schema Version to conditionally run update scripts against my database which works great, but I have one script that I need to run regardless of what schema the database is on. How do I tell an SQL Script to run regardless of Schema Version?
Any help would be much appreciated.
Any help would be much appreciated.
(3) Replies
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎May 27, 2008
07:52 AM
If you do not specify a schema version number on the General tab for a SQL script in the SQL Scripts view, the script is always launched.
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎May 27, 2008
09:32 AM
You could run it using ADO Objects in the OnFirstUIAfter Event or when you want.
Here is a link to an example of running a SQL in ADO objects.
Here is a link to an example of running a SQL in ADO objects.
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎May 27, 2008
10:47 AM
Thanks for the replies. Much appreciated 🙂