Timeline for sql migration - decoupling deployment from execution
Current License: CC BY-SA 4.0
14 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| May 31, 2023 at 15:13 | vote | accept | dot | ||
| May 24, 2023 at 20:30 | comment | added | Greg Burghardt | There is something philosophically elegant about testing for your own existence, and upon discovering you exist, assuming you have already fulfilled your purpose. | |
| May 24, 2023 at 19:29 | comment | added | Doc Brown | @GregBurghardt: ;-) after thinking twice about it, I think not deleting itself maybe the better option, see my edit. | |
| May 24, 2023 at 19:27 | history | edited | Doc Brown | CC BY-SA 4.0 | added 209 characters in body |
| May 24, 2023 at 19:25 | comment | added | Greg Burghardt | A stored proc that destroys itself after executing absolutely must be put in MissionImpossible.sql - this stored proc will self-destruct after completion. But then we have copyright issues... | |
| May 24, 2023 at 19:25 | history | edited | Doc Brown | CC BY-SA 4.0 | added 45 characters in body |
| May 24, 2023 at 19:23 | comment | added | Doc Brown | @GregBurghardt: the OP mentioned AliaSQL and a pipeline. I took a short look into the manual: it is a tool for DB migrations which executes SQL scripts whenever someone says it has to. Hence installation and initial execution of the SP should be just a script in the Everytime folder used by AliaSQL. | |
| May 24, 2023 at 19:20 | history | edited | Doc Brown | CC BY-SA 4.0 | added 113 characters in body |
| May 24, 2023 at 19:17 | comment | added | Greg Burghardt | I was a little confused by the SO answer as well. I think the answer mentions rebooting the database so it runs the stored proc right away. If you don't reboot, I imagine the stored proc runs at the next scheduled time. Am I interpreting that correctly, Doc? | |
| May 24, 2023 at 19:14 | history | edited | Doc Brown | CC BY-SA 4.0 | added 374 characters in body |
| May 24, 2023 at 19:12 | comment | added | Doc Brown | @dot: the "database startup" is completely irrelevant in the example. The point is, a SP can wait for doing certain actions until a defined point in time (as you said, like a cron job). Maybe you read the SO post again? | |
| May 24, 2023 at 19:09 | history | edited | Doc Brown | CC BY-SA 4.0 | added 374 characters in body |
| May 24, 2023 at 19:07 | comment | added | dot | I'm very familiar with a stored proc ... but as far as scheduling itself... i see the example is on database start up. But I would like to know other trigger options. What should I google? | |
| May 24, 2023 at 19:03 | history | answered | Doc Brown | CC BY-SA 4.0 |