I suggest you ...

Migrations

What do you suggest people use for migrations? All run outside of appharbor?

143 votes
Vote
Sign in
Signed in as (Sign out)
You have left! (?) (thinking…)
ferventcoderferventcoder shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

8 comments

Sign in
Signed in as (Sign out)
Submitting...
  • erichextererichexter commented  ·   ·  Flag as inappropriate

    AH has been such a great dev and deploy story for me. This is the one must have feature that is still needed.! Even if the first pass only supported upgrades, that would be huge.

  • PawelPabichPawelPabich commented  ·   ·  Flag as inappropriate

    Until you guys come up with a comprehensive solution can you just simply call a well defined MsBuild target and let people deal with database upgrades?
    E.g. UpgradeDatabase and DowngradeDatabase. In most cases UpgradeDatabase will be enough. It's better to have something now then nothing for long time and force people to use hacks :). UpgradeDatabase should be called right before the app gets deployed to a web server. More details here:
    http://www.pabich.eu/blog/archive/2011/03/28/Automated-database-deployments-to-AppHarbor.aspx

    Any thoughts ?

    Pawel

  • ferventcoderferventcoder commented  ·   ·  Flag as inappropriate

    I don't want to limit people from using their framework of choice for migrations. Everyone has different opinions and that is fine, that's why there are so many options. :D

    If you decide to make it pluggable, just let me know how I can hook RH into it so it can be an option.

  • ferventcoderferventcoder commented  ·   ·  Flag as inappropriate

    Disclaimer: I am the maintainer of a migrations tool named RoundhousE.

    I use RoundhousE (RH) together with FNH/NH and SchemaExport (during initial development) / SchemaUpdate (once in production) to drive migration changes.

    RH uses plain old sql scripts to drive changes to databases. It doesn't yet support MySQL, but that doesn't mean it can't very quickly support it.

    http://projectroundhouse.org (the download comes with a sample for SQL to show how it works).

    I work on a set of tools known as the Chuck Norris Framework. We dub it as a developer productivity suite because it allows developers to get framework concerns out of the way. We are focused on removing pain, which seems very close to what AppHarbor also does. :D

  • ttAdmintt (Admin, AppHarbor) commented  ·   ·  Flag as inappropriate

    This is something we are thinking a lot about!

    We should at some point begin to integrate with popular frameworks, so we'll automatically migrate/rollback the database as necessary, but currently you'll have to do it yourself. Any suggestions on frameworks would be great.

    For AppHarbor, we're using the `SchemaUpdate` feature in NHibernate, which will create any missing entities in the database when we're initializing our repository...

Feedback and Knowledge Base