How to Execute old sql scripts only if there is any change?

Narendher Babu A

9y839

For eg.

If a table has 10 lakh records. If i run the script it will update the 10 lakh records.

Now, if i run the same script again it should not be executed because it was already executed before and also the table should not update since there is no change in the script .

Now, if the script is changed it should execute now....please help

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Nilesh Shah9y ago
Accepted answer
It seems you can not find solution to your problem because the "problem" itself is incorrect.
Whoever has asked to do something like this either does not know how SQL server operates or even does not know software development fundamentals.
A script in SQL server should handle by itself if some data needs to be updated or not.

Scripts are meant to be executed as many times user wishes, not once. Even if you find out some solution that checks if a script is changed or not, imagine someone placing a space or simple select statement in it, which means your logic will identify script is changed and will execute it again.

so come to reality, write something which follows simple software development standards, and dont run behind some "out of the world" solution for simple and routine tasks.
Narendher Babu A9y ago
but in this case modified script should run at any time
Amit Gupta9y ago
Your question was quite identical to tge previous one that was accepted by you as a coreect answer, please donot repeat the same question, if there was any required clarification then do ask on that post only.
Gokhul Varman9y ago
please refer the link for the detailed explantion:https://documentation.red-gate.com/display/SOC5/Working+with+migration+scripts