redgate have a tool for generating test data that looks quite good. I don't know how much it costs but it would save a lot of effort.
https://www.red-gate.com/hub/product-learning/sql-data-generator/how-to-generate-various-forms-of-realistic-data-for-testing-development-and-prototypes

Misha_SQL
You might need to add System.Data to the project...

VB Script is different from normal VB, you can't declare a variable to be a type. e.g. you can't do "Dim i as integer" you just have to do: "Dim...

It look like the script shouldn't run at all.

you have
you have Dim oExcel As New Microsoft.Office.Interop.Excel.Application = Nothing
then later down you have:

Working now on this link: http://www.sqlservercentral.com/articles/ADO.NET/168710/
But not the one at the top of this page (https://www.sqlservercentral.com/articles/C%23/168710/)

The article isn't available

7. on the cloud you are using someone else's machine

Have you tried updating the FK column values to NULL before deleting the rows?

One of our systems has about 500 stored procedure scripts that need to be run on a release. To do this I concatenate all the scripts together in one file....

All other things being equal it will take longer to update the table with more columns. If only because there is going to be more disk IO in reading the...

If you set the compatibility level on the database to 2008, do queries still take a long time to run?

I'm not sure, I didn't mean Regions( RegionID) as that's already the PK.
Just ignore that index for now.

Try adding the following indexes
CREATE INDEX IX_#ReportDealCore_1 ON #ReportDealCore(DealID)
CREATE INDEX IX_Activities_1 ON Activities(DealID,Type)
CREATE INDEX IX_DealProperties_1 ON DealProperties(DealID,IsMainProperty,DateRemoved)
CREATE INDEX IX_Regions_1 ON Regions(CityID)
CREATE INDEX IX_DealsToClients_1...