3 ms·
It takes few days for one to create migration tool that uses SQL files using shell only (for example PoweShell being a serious language is awesome for this). I
by majkinetor 5y ago
It takes few days for one to create migration tool that uses SQL files using shell only (for example PoweShell being a serious language is awesome for this).
I did that on number of projects and it works like a charm. I can create any type of ad hoc workflow developer needs. For example most of them want functions/types/sprocs recreated each time on each migration which is trivial to do in shell. Some of the devs had really wired but useful wishes that I was able to trivially easy do. Afterall, its just executing sql scripts 1 by 1, optionally with transaction started before that.
Nobody ever used down migrations so not sure why people still do that.
Shell is mandatory because I may want to do any number of things around migrations that require feedback from it (for example installing DLL files on Sql Server server or forcing backup just before migration).