Can FluentMigrator output one SQL file per migration?

Question

I want to know if I can have one SQL file per migration.

We are trying to use it with RoundhousE, but RoundhousE will stop if a SQL file already ran is ever altered.

Any ideas?

What is the output command you are using to generate the sql from FM? — ferventcoder, Sep 21 '13 at 18:19
I think I need a bit more info on why you want to alter the sql file? Why would you want to change the file after deploying the change to your database schema? FluentMigrator allows you to rollback your change but you would not go back and change an already deployed migration. So more background info, please. — Daniel Lee, Sep 22 '13 at 14:23
@DanielLee - RoundhousE (Chuck Norris FW) will throw an error if the script is ever modified. FluentMigrator outputs only to one file, and RH checks the hash of that file. — Sam, Sep 22 '13 at 17:56

Sam · Accepted Answer · 2013-09-22T23:21:55.530

2

I solved this issue by forking FM and adding a DirectoryAnnouncer that then outputs one file per migration (named after the migration #).

edited Sep 22 '13 at 23:21

answered Sep 22 '13 at 17:57

Sam

3

Any chance you could send in a pull request? Sounds like a nice feature to have. – Daniel Lee Sep 22 '13 at 18:08

1 Answers1