Run SQL Script against all Schema Versions

[John_Farkas]

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.

[DebbieL]

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.

[TheTraveler]

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.

[John_Farkas]

Thanks for the replies. Much appreciated 🙂