Search code examples
database-migrationlegacy-databaseroundhouse

Retrofit DB for use with RoundHouse

I'm looking into getting our db into source control. I can't find any info on the best way to retrofit existing dbs for use with rh.

I can see the tables created should I just script those out and add them to our db and things will proceed from there? Or should I get a bak of the db and run rh with restore flag? Seems like there should be some guidelines of this.

If you have any insights please let me know.

thanks

Solution

  • Have you seen PowerUp? https://github.com/chucknorris/powerup

    This is a utility to extract current items out of a database into an idempotent RoundhousE format.

    As far as tables, you can script that out separately and then put those into a runAfterCreate table.

    There is a little guidance in the wiki on this - https://github.com/chucknorris/roundhouse/wiki/RoundhousEModes