Is there a way to record Production SQL queries and workloads so that they can be replayed in another environment?
I can see that the tool has a degree of control over connectivity but is it possible to schedule and monitor SET exports/imports from the command line?
Also how long would it take to complete a SET export/import a 100TB database - days/hours/minutes?
If you want to move big volumes between systems, you could try Datamover or you could write your own processes. The time will vary depending on many factors (hardware, communications, etc...)