Copy a subset of data from PRD to DEV
We're trying to determine if there are any products out there (3rd party or SAP delivered) that will provide this kind of functionality:
We want to selectively copy a subset of data from our Production system and copy this data to a test client on our Development system (we can't do client copies because of our database size). Our current R3 database is 5 TB (yes, we're archiving as fast as we can) so we're trying to find a solution to selectively copy data. We currently perform redirected restores with DB2 but we can't perform a redirected restore from PRD to DEV.
Please let me know if anyone has heard of a software package that will selectively copy data from PRD to DEV. Thank you.