Error validating migration scripts
Published 25 August 2016
You may encounter a validation error when committing migration scripts. This page gives you more information about why the error has happened, and what you can do to fix the problem.
Why has this happened?
When you commit a migration script, we validate your repository to make sure that we'll be able to deploy it. If validation fails, the migration script cannot be committed.
Why does validation fail?
When you merge multiple branches together that contain migration scripts, validation can fail.
When you commit a migration script, we store the state of your database before the migration script is created. After a merge, it's not possible to know what the correct state should be. We store the merge result as the state of the database, but sometimes this is incompatible with the changes you've made.
What can I do?
We need to change the state we've stored for some of the existing migration scripts in your repository.
These steps may fix the problem:
- Delete the most recent migration script from your repository.
- Commit the deletion.
- Create a new migration script with the same content as the deleted migration script. Make sure that this migration script still runs on your database.
- Commit this new migration script.
- Commit the migration script which caused the error.
If validation still fails, contact support@red-gate.com.
