Trying to apply migration script - "Failed to apply migrations" error

DylanP

We have started trying to use separate development databases for each developer. I made some changes on mine, including two migration scripts, and committed those changes, and pushed the master branch. My colleague pulled the changes, and then of course the plugin asked him to apply some unapplied scripts (two migration scripts and four programmable object scripts).

He clicks apply, and immediately this error shows up: "Failed to apply migrations. Unable to load deployment script template Migration"



What does this mean? How do I fix it? It's not very helpful.

The way I asked him to get around it was open the migration scripts, execute them manually, then mark them as applied, and that worked. Not a good way to keep moving forward, though.

squigley

Good Afternoon!

Thanks for your inquiry and sorry to hear about your issue with SQL Change Automation.

Can you try restarting SSMS on your end to see if that helps?

DylanP

I'm guessing it did. I haven't heard back specifically but it seems to be working for him now. I guess it had just been a while since he'd restarted. Still a rather unhelpful error message though - maybe you can edit these message internally to say "We suggest you restart SSMS".