Upgrading from MSbuild 2015 to 2017 fails on __MigrationLog table
We have recently took the scary but needed step of upgrading from msbuild 2015 to 2017 and encounter the following error:
N'The ReadyRoll [dbo].[__MigrationLog] table has an incorrect primary key specification. This may be due to the fact that the <ReadyRollToolsVersion/> element in your .sqlproj file contains the wrong version number for your database. Please check earlier versions of your .sqlproj file to determine what is the appropriate version for your database (likely 1.3.1).
If we wanted to upgrade to the latest version how would we do that?