Is there a simple way to tell alembic to migrate to a specific revision?

database database-migration alembic
Matt picture Matt · May 4, 2016 · Viewed 10.8k times · Source

Alembic has commands to upgrade and downgrade to a specific revision, e.g. on the command line:

alembic upgrade <target-revision>

And

alembic downgrade <target-revision>

Is there a simple way to migrate to a specific revision if you don't know whether it's an upgrade or a downgrade? i.e.

alembic migrate <target-revision>

I can work out the direction by looking at the history, current and target revisions, but this feels like fighting the library. Am I missing something or is there a reason why this isn't provided out of the box?

Answer

Matt picture Matt · May 7, 2016

It turns out there's a very simple, pragmatic solution to this:

alembic upgrade <target-revision> || alembic downgrade <target-revision>

Related questions

How do I move a redis database from one server to another?

I currently have a live redis server running on a cloud instance and I want to migrate this redis server to a new cloud instance and use that instance as my new redis server. If it were MySQL, I would …

Read More
Sequelize.js: how to use migrations and sync

I'm close to having my project ready to launch. I have big plans for after launch and the database structure is going to change -- new columns in existing tables as well as new tables, and new associations to existing …

Read More
Laravel : Migrations & Seeding for production data

My application needs a pre registered data set to work. So i need to insert them in the database when i set up the application. Laravel propose two mechanisms : Database migrations : "They allow a team to modify the database schema …

Read More