Squash / Merge Migration Files

[halorium]

I'd love a way to squash / merge the migrations into a single file (think of it like spring cleaning) once the list of migrations gets too long and unwieldy.

I did this once manually a long time ago and it was very time consuming and error prone.

Basically the current state of the db needs to be captured as a single up migration as well as any insert statements and the version table needs to be updated to that newly created migration.

I'd love to hear of any suggestions in the meantime.

Thanks