Just checking if I am doing the correct steps, or if there is a smarter way.
We have UAT databases that we set up from Live ones (suitably anonymised of course)
to refresh a UAT one :
export the data from Live
drop the UAT user
clone my ‘template’ user and call it the UAT name
import the data to UAT
run my anonymise scripts.
Is there a way to just clear all the data from the UAT user ? Then I could skip the drop / clone steps