>Create a sandbox copy of your live data to perform each test in, and let it process normally. After validating it is correct, delete the sandbox, or re-initialize it to its "default / empty" state.
Yes, this is nice. But, in production, where needed to enable the startup of a rollback transaction in regards to various SQL commands executed in sequence, where one involves a child table based on a newly created record from a parent table from within this transaction, how would you see such possibility of rollbacks?