THIS IS A TEST INSTANCE. ALL YOUR CHANGES WILL BE LOST!!!!
...
This script should be run intially to move values from square_footage to facility_size and set the Uom
update FACILITY set UPDATE Facility SET facility_size=square_footage;
update FACILITY set UPDATE Facility SET facility_size_uom_id='AREA_ft2';
then the square_footage column might be removed
ALTER TABLE Facility DROP COLUMN square_footage;