Re: Refreshing data on a test database

>If your physical layouts are the same, why not restore a production backup to >the test system. That's how we do it. It's a LOT faster than >dbexport/dbimport.< Unfortunately we already maintain a "contingency" server on the same UNIX box as the test one. This contingency server is refreshed by a tbtape restore as you describe. >When I restore test from production, I run a script that goes to my $SCHEMA >directory and runs the designated SQL commands. < Any chance of a look at the script to save re-inventing the wheel? >Another option might be to do a diff between your production databases and test databases and apply the differences to your test system, but that sounds a bit tricky.< Yes, I think it would be fine for a one-off, but sounds like the sort of thing that would be a pain in a regular script. Thanks for your help Neil Truby Chase Manhattan uk.clientservergroup@chase.com and ntruby@netcomuk.co.uk