We are having license copy of SQL Compare and multiscript.
We have one requirement which I don’t know how to achieve.
We need to upgrade database when we want to upgrade to higher version.
For this we have sets of SQL queries that needs to be applied before SQL Compare and synchronies.
Now this set varies depending on the version to which we want to upgrade the database.
i.e. if we want to update it to
Version 1.1 – 6 sql scripts needs to be applied,
Version 1.2 – 9 sql scripts needs to be applied,
Version 1.3 – 8 sql scripts needs to be applied and so on.
If we use SQL Multi Script than each time we have to select that many scripts.
Instead of this if we have file containing list of this script than on loading this file all the sql script should load.
Can you suggest solution for the above situation?
Mr Nehal Shah
PS: Let me know if i am in the wrong forum.