Home » Other » General » Creating dev db from prod
Creating dev db from prod [message #263032] Tue, 28 August 2007 16:43 Go to next message
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?

Re: Creating dev db from prod [message #263035 is a reply to message #263032] Tue, 28 August 2007 19:15 Go to previous messageGo to next message
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.

Re: Creating dev db from prod [message #292749 is a reply to message #263035] Wed, 09 January 2008 15:37 Go to previous messageGo to next message
Messages: 7
Registered: December 2007
Junior Member
Check this link...
Re: Creating dev db from prod [message #292754 is a reply to message #263032] Wed, 09 January 2008 15:47 Go to previous message
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
never used it.
just heard about it & remembered the name.
Previous Topic: Procedure is not working
Next Topic: Data Structure Optimization
Goto Forum:

Current Time: Sun Jun 20 16:41:12 CDT 2021