How to Copy Application data from Prod to Another System

If I want to copy only certain portions of application/transaction data to another client on a different system (i.e. copy Prod Client 500 data to QA client 200) , what is the best method for doing so? Is it possible, or do you have to copy everything (either the entire database, or just all of the application data, etc.)?