How to: Create repeatable transforms on a given database schema

[andrewksmith]

I wish to create a script with parameters which will allow me to transform an input SQLServer database schema.

For instance, I wish to amend some but not all tables in the input schema to be system versioned including adding new start/end datetime2(7) columns with defaults. I would like the defaults themselves to be created as a transform I can run before running this transform.

Suggestions please.