Easiest way to copy date from multiple related tables to a test Database
Posted on 2005-05-05
Can anyone tell me how I can copy records from multiple tables in a DB to a test DB. Lets say I have data in 5 related tables, is there anyway to write a query to get this data from all the tables and then copy it to either their corresponding tables in the test DB or temp tables. If not, is there any faster way than either manually copying the records from/to each table or using "insert into" on each single table.