Code Outside of the Box

« The Database Versioning Showdown Speaking at SQLSaturday Atlanta in May »

Introducing Horton

First published on April 3, 2016


What is Horton?

Horton is the simple database migration utility. It’s a little program that does one thing: enables versioning of database schema through SQL based migration scripts.

You’ll find a “getting started guide” in the project’s GitHub repository. Horton is also released through GitHub. You can find and download the latest release from the releases tab.

What does it do?

It may help to read this first: I recently wrote about database versioning with migrations.

Horton handles migrations for schema objects and desired state for “code” like objects (stored procedures, views, etc.). It was written to help apply database change scripts to production servers in a fully predictable and automated fashion (i.e. continuous deployment). It’s grown a number of features in recent years, but has never strayed from its very focused purpose.

Why am I “Introducing” it now at version 4.0?

Horton is actually the latest incarnation of a SQL migration tool I wrote almost seven years ago. The first commit was in September 2009! And even though it was published on GitHub, it was always just an internal tool and I never treated it as a real open source project. But I’m trying to change that.

Versions 1-3 did not strictly follow semantic versioning either. There were few, if any, breaking changes over its lifetime.

For version 4, I decided to rewrite it.

I’d love for folks to give it a try and provide feedback. Enjoy!


Comments are not moderated. But I reserve the right to delete anything hostile, offensive, or SPAMy.