I'm upgrading a CMS + Commerce site from CMS 11 and Commerce 13 to CMS 12 and Commerce 14, but running into serious problems regarding SQL migrations.
I started digging into it and compared the SQL scripts of Episerver.Commerce.Core 13.32.5 and Episerver.Commerce.Core 14.5.0, and found out that the SQL scripts for schema versions 10.0.31 and 10.0.32 are completely different! So, the "same" files in the two Nuget-packages are different - they should be 100% equal. I've only checked 10.0.31 and 10.0.32, so I can't speak for earlier versions.
You are absolutely correct. there seems to be an oversight, as we continue to provide bug fixes on 13.x, newer 13.x versions might contain db changes. as we should have changed the name of files in 14.x to 11.x.x.sql instead of keeping it 10.x.xsql.
I will file a bug to Commerce team
THe bug is COM-16255 and it's being worked on with high priority