Thank you, that link was super helpful!
I hadn't spotted the "Add Migration Script for Specific Changes" feature in SQL Source Control! The reason for this oversight is that our current SQL Source Control license is for v. 2.1.1, which doesn't have this feature, and it was only last week that I started playing around with the current version of SQL Source Control.
I'm quite positive that this feature covers everything I need when it comes to migration scripts. Otherwise, I'll post my wish list!