Since this post is still awaiting moderation (:P :P :P). What I ended up doing is:
- Creating script from here for schema only: https://accessexperts.com/blog/2014/06/25/copying-data-two-azure-databases/
- Remove all ledger references (LEDGER=ON and columns) from generated script from previous step
- Using SSMS, right-click destination database in Azure and use Task ->
I also had to Enable Identity on columns for the generated SSIS package. I am not entirely sure the data is OK as I still have to deploy application code (Azure DevOps) but this got me moving so I can attend to the next fire.