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

Question

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

Nilesh Shah · 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 A · Answer

but in this case modified script should run at any time

Amit Gupta · Answer

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 Varman · Answer

please refer the link for the detailed explantion:https://documentation.red-gate.com/display/SOC5/Working+with+migration+scripts