One or more migrations have changed

__chris

We have migrations which have run on a dev database. We've committed these changes to our code repository. During our deployment process, on our build servers, our build process will check out the code from the repository and run any migrations which have not yet been run on the database specified for the build. This has been working pretty good, but currently we are receiving the error during a build process:

An error occurred while attempting to perform drift analysis on your project: One or more migrations have changed. Please refresh the list of pending changes and re-attempt synchronization.

Unfortunately the message does not tell us what changed. Manually pointing ReadyRoll at the database in question and performing a sync does not reveal anything. What's the best way to troubleshoot this?

dnlnln

Hi Chris,

Sorry that you're running into an error there. Firstly you might like to disable drift analysis while we figure out the cause of the problem. This can be done by adding the following system property to your TeamCity build configuration:
System.SkipDriftAnalysis = True

Then would you mind adding the following to the Command Line Parameters field of the build step within your build configuration:
/verbosity:diagnostic

When you next perform a build, this will output additional detail about how the Shadow database is being deployed.

If you could copy the text from the output and send it to support@red-gate.com mentioning this forum post, I will look into it further.

Thanks!

__chris

Thank you. I'll follow up through email.

dnlnln

Got it, thanks Chris. Will be in touch shortly.