OraFAQ Forum: General » Creating dev db from prod

Home » Other » General » Creating dev db from prod

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Creating dev db from prod [message #263032]

Tue, 28 August 2007 16:43

TLegend33
Messages: 203
Registered: March 2005

Senior Member

We currently employ a very cumbersome method of refreshing our development environment with production data. It involves dropping constraints, importing records, resetting sequences, recreating triggers, enabling constraints...etc. The enabling of constraints is especially arduous as the data in prod does not match the data in dev (lots of orphaned rows).
Naturally, our production database is too large to merely copy over to our development environment. I have to assume many people have encountered this issue before.
Unfortunately, there's no simple method of selecting a subset of production data and migrating it to development.

Have any of you encountered this issue before and do you follow a particular practice? Or is this question too vague as everyone's data and application functionality is different?

Thanks.

Report message to a moderator

Re: Creating dev db from prod [message #263035 is a reply to message #263032]

Tue, 28 August 2007 19:15

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

I have a few options for you. Get a machine onto which you can copy the database at the file level. How can you do performance tuning if you don't having matching hardware?

You say that the import is failing because of constraint issues during the import. Then instead of doing a full export, export the tables in the order in which they need to be reloaded. If you have many, many tables then do the 'must have' export by table name, and then do a second export of all the tables that haven't been already exported. Then import the 'must haves' and then the rest.

David

Report message to a moderator