https://www.red-gate.com/products/sql-toolbelt-essentials/ - I got bit because I can't restore to an older version of #MSSQL. The DacPac failed too for some hand-wavy reason. I reached for #Redgate #SQLCompare and #DataCompare and built a script that got it done. Just saying, Redgate lives up to the moto of "ingeniously simple".