Seperate Repositories: Acceptance Testing and Database Migrations

I have an issue in both the projects that I’m currently involved in and it has to do with debugging issues in previous versions of the application. In essence I cannot run an older version the application as my current database schema is newer than the model objects that map to it. Essentially I need a way to rollback a few database migration scripts so that I can run the application, or alternatively recreate a fresh database. This later solution should always be available, but as of now neither of them can be done. If the version I’m trying to run is the current production’s version, fortunately I can use a SQL dump of the production database to fix my error and allow the application to run.

Advertisement