How and when would I implement some code which would take data from one part of the Db and put it in another?

How and when would I implement some code which would take data from one part of the Db and put it in another?