Who says we don't upgrade in place?

My product line was recently required to perform an upgrade (Standard Edition, SQL 2016 to SQL 2019) of every SQL instance, production and non-production,...

Since the database itself is a "schema", I'm using the term "subschema" to refer to the database subdivisions including "dbo".

Our primary database schema uses (sub)schemas in two different ways. First, logical separation into "namespaces", keeping the accounting objects in [acct] and the email objects in [mail], etc. ...