SQL Change Automation Changing Version in Visual Studio

Sneaky_Weasel · February 20, 2020 8:49AM

Hi,

I have SQL database project in Visual Studio that goes through an Azure Devops pipeline to Dev, Test and Live. A problem has recently started that when it tries to deploy to the Dev version, it fails saying

The database snapshot was saved by a newer version of SQL Compare

Searching the web seems to suggest that I need to change a setting in SQL Change Automation to set it to a previous version to resolve, but I can't find that setting in Visual Studio SQL Change Automation. Please help?

Cheers,
Matt

Eddie D · February 21, 2020 10:23AM

Hi Sneaky_Weasel,
Thank you for your forum post.

I suspect that you are using the Azure DevOps Add-On for the release process. You can select your SQL Change Automation job in the tasks list and edit the task. Change the SQL Change Automation version:

Image: https://us.v-cdn.net/6029854/uploads/editor/ua/27va4xiflxyd.png

I hope the above helps.

Many Thanks
Eddie

Sneaky_Weasel · February 24, 2020 12:06PM

Hi Eddie,

Thanks for your reply. My Azure Devops is set to 4.* and latest. Is that correct? Or should Devops be set to an otder version?

Image: https://us.v-cdn.net/6029854/uploads/editor/4t/gru86gtyw9kh.png

Many thanks,
Matt

Eddie D · February 26, 2020 4:29PM

Hi, thank you for your reply.

Correct, it is my understanding that would use the drop down to select a SQL Change Automation version that matches the earlier version you require.

Many Thanks
Eddie

SQL Change Automation Changing Version in Visual Studio

Answers

Product Learning

Community Forums

Events & Friends

Simple Talk