copy production data to test
Hi,
Does anyone have a script that can give me a tree structure of all the dependent tables. I am trying to load a few tables(10 out of around 250 tables) in my test database with partial data from production. The problem is I get lot of referential integrity errors. I am right now manually trying to find out the dependents and loading the data, but the whole process is taking longer time. I would like to know if anyone has any similar experiences loading partial data from production into test database.
something like.... If I give my 10 table names to the script...the script would give me all the tables I need to load...and also the order .
Thanks in advance
-JS