Step 4

Copy Data

Using the "SQL Set Rewrite Parser" engine, SQL Simulator takes the SQL and rewrites it so that retrieves only the needed records from production and copies them to the simulated database.

If there are any foreign key tables those tables will get populated automatically by the "SQL Set Rewrite Parser".

If you omit the where clause in your SQL then the entire table will be copied.