- i have a system with dew version. any version has 5-9 upgrade scripts. in order to upgrade version 1 to 5 i have to run each script in any version in the correct order (01_script, 02_script, 03_script...) if the installed version is 01, i start running to script from version 02 i have table with the value of the version number that also written in registry.
i have the ability to take all script and union them into one script
how can i make a script which will check the version and start running the correct script?
(sql server 2008r2)