I am trying to build an installer that hosts several SQL Scripts each for a different version of the database.
What I am trying to accomplish is run a single installer to bring any of our clients up to the latest build of the database. The database itself has a table that indicates what version the user is currently on.
Is there a way to capture what version the database is on and conditionally run the upgrade scripts?
Currently if the user is behind 2 or 3 versions, they have to run each setup file to incrementally upgrade there database.
Thanks