If you provide your sample data in a more accessible form, like this, you will probably get more responses:

DROP TABLE IF EXISTS #Transaction;

CREATE TABLE #Transaction(Transaction_Id INT, Date_Transaction...

This question is strikingly similar to this one.

Perhaps the responses you received there were not to your liking? You did not even have the courtesy to respond to the...

Whoever asked you to do this needs to...

This possibly means that there is a 32-bit version of the driver installed on the server but not a 64-bit version.

I suggest you get out of the habit of writing = NULL. Instead, write IS NULL. NOT is very useful, do not discard it!

Presumably BACKUP/RESTORE is not an option.

For the volumes of data you are talking about, I'd probably use a pipe-delimited...

FORMAT is not 'tricky',...

It seems that you're not trying the suggestions here with any great application.

Instead, you appear to be waiting for someone here to write the solution for you. Unless you can...

Use something like this to generate the statements for changing DB ownership to sa

USE master;
GO

SELECT name
      ,SQL = CONCAT('ALTER AUTHORIZATION ON DATABASE::',...

Yikes, a WHILE loop. No wonder it's slow.

The following query should do the UPDATE in a single hit. But please test it thoroughly before running it anywhere important.