Have a look at :

• "Service Broker Part 1: Service Broker Basics"
• "Adventures With Service Broker"
• "How to troubleshoot Service Broker problems"
• "Troubleshooting Service Broker (SSB)"...

Going backward over version(s) is always a hard time.

As you've figured out, the only way is a scripting and data migration solution.

On the other hand, since sqlexpress is free, why...

Thank you for the cautions, Grant.

I always develop xEvents related stuff on my local box, then on a dev box, then on a QA box and only then ....

As you...

"RETURN EXECUTE ..." ? ( I never used this consturction )

Did you verify the database backup at the source server?

Nowadays we experience more and more "shadow IT". Meaning people at the business side gaining knowledge about some "new" programming tool / reporting tool / skills driven language / ......

Check sys.foreign_keys ( did not read the full Q )

Indeed, some tools can suggest logical relationships. Mostly based on column name and data type.

However, that must still be double...

How did you provide access to the backup file on blob storage to your SQLMI ?

of course there was a #sarcasm LOL reading this post.

- None of my business side (in-house) clients cares about performance and scalability, but all want best ... until shown the...

did you check with this soluiton ? "Tally OH! An Improved SQL 8K “CSV Splitter” Function"

And its followup comments

how about

go
Declare @Festivaldates TABLE 
             ([createdate]  date NULL
      ...

Also keep in mind you can use QueryStore to have query followup.

Interesting with this is you already have  reports at hand to help you dig into it all

I would go for eXtended Events to capture such information.

could be something like this:

-- Create the event session
CREATE EVENT SESSION DBA_LongRunningQueries ON SERVER
ADD EVENT sqlserver.sql_statement_completed (
 ...

If it is an Azure SQLVM, I would prefer my Azure provider/facilitator to drop the Azure SQLVM and provide you an Azure SQLVM that matches your specs.

That are indeed valid arguments to take into account.

Our world is mainly about being able to cooperate !