Blueprint: Disk space requirement on SQL server to perform a Blueprint version upgrade.

Question:

How much disk space on the SQL server is required to perform a Blueprint version upgrade?

Environment:

Blueprint Enterprise 5.0 and greater

Information:

During the upgrade of each job partition, the jobs data is written out of the databases to CSV via BCP and then written back in after the schema has been updated. This is done one partition at a time, with the jobs being written to a file named “oldJobs.csv” in the data directory.
 
 The background logic is:
 
 For each psjobsX partition
 begin
     If oldJobs.csv exists, delete it.
     Write data from SQL partition into oldJobs.csv.
     Update partition schema and import jobs from oldJobs.csv into partition
     Delete oldJobs.csv
 end
 
 In regard to the disk space requirement:

•  To upgrade a partition, allow for free space equal to 2x the size of data in use for the partition.  Find the largest job partition, and make sure there’s 2x its size free.  (Note, no need sum of size of all partitions, just size of biggest one.)
 
 •  To upgrade the data warehouse, the logic completely rebuilds the warehouse.  Allow free space equal to 2x the existing size of warehouse for the rebuild.