SQL Scripts With Green Ticks

Running SQL install scripts can be tedious. They get so far, and then fail. Finding out where they failed isn’t always easy and when the problem is fixed, there is a choice – drop the schema and re-run, or comment out what has been applied already, and re-run. I once spent an entire morning in this fix/re-run cycle for a particularly large and badly maintained script. It was very ungratifying work. What I need, I thought, are some friendly green ticks, some positive visual feedback to aid job satisfaction.
Continue reading