Cleanup SQL migrations, simplify deployments

Perhaps add Chuck Norris Roundhouse to create versioned SQL scripts generated by EF?
Ideally something that works with Octopus deploy or MS Build/deployment which will allow up/down migration of SQL Db changes along with code deployments