I think I wasn't quite clear with the requirements. In a simple example, let's say we have a customer who has placed three orders for a few different products each time. Say that is customer #123, with order#6567, 6598, and 6895.
If we wanted to clone that customer, we would end up with an exact duplicate customer with a new ID (say, 754) and that "clone" would also have three orders, which woudl be exact copies of 123's three orders.
So, we need to insert a record into Customers that generates a new ID and then creates new Orders that are duplicates of the original customer's orders, which also have new ID's.
The issue is that our data model will require parent/child relationships over 150 tables.
So, can the tool be told to add records through the data structure, but instead of using "randomized" content, can it duplicate specificed existing content?
We'd really love to buy the product, but the requirement is absolute--we need to know it can do _exactly this_.