Re: Methods to Create Smaller Test DB from Production?
- From: Mladen Gogala <mgogala@xxxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Tue, 2 Mar 2004 06:50:37 -0500
$50,000 for 10 users.
On 03/02/2004 04:27:05 AM, chris@xxxxxxxxxxxxxxxxxxxxx wrote:
> Mark,
>
> Sounds like a great product. Any idea what the rough cost for "Move for
> Servers" is?
>
> Thanks,
>
> Chris
>
> PS I was involved in writing a bespoke tool for one system I used to work on.
> It took 2 of us a couple of months if I remember correctly (it was 1997). It
> wasn't perfect but the developers and management thought it was great and
> used
> it every day to extract small numbers of accounts for bug fixing, testing
> etc.
>
> Quoting Mark Richard <mrichard@xxxxxxxxxxxxxxxxx>:
>
> >
> >
> >
> >
> > Let me support Mladen on this 110%.
> >
> > I use Princeton Softech's "Move for Servers" product and it does exactly
> > what you are after. Let me elaborate on our scenario for you...
> >
> > Our production instance of over 1TB, from there we use backup tapes to
> > restore a volume testing environment once every so often (this acts as a
> > recovery test of sorts as well). From here we use Move for Servers to
> > create many small test and development databases (about 20 of them
> > currently active). We have no Referential Integrity defined within our
> > database (not my preference) so I had to manually teach the tool about each
> > relationship. Then I select the tables that I want extracted and define
> > limits. For example, I have one extract to get all referential data
> > (perhaps 50 tables), one extract to get data based on customers (about 80
> > tables) and several other adhoc extracts to meet specific requirements
> > (such as testing a specific defect). Once the initial definitions are
> > created then maintenance is a breeze.
> >
> > To build a new database I create the structure from DDL (Move for Servers
> > can do this but isn't flexible enough for my preference), then load a
> > Reference extract and then load a 500 Customer extract. To extract all
> > data for 500 customers (from perhaps 500,000 - 1,000,000 customers) from
> > our system takes about 3-4 hours and then to load this into a new
> > environment takes about 15 minutes. I keep the extracts once created so
> > that I can load into multiple destinations quickly.
> >
> > I could talk for hours about Move for Servers - there is a wealth of
> > functionality in there once you start to understand the tool and their
> > support and pricing are wonderful. So ignore those people suggesting you
> > roll-your-own unless you are a sucker for punishment. Did I also mention
> > that Move for Servers can move data between different RDBMS's - so moving
> > data from Oracle to SQL Server (for example) is possible? That may or may
> > not be a feature of importance to you. If you have any further questions
> > let me know. I can also put you into contact with people from Princeton
> > Softech if you wish.
> >
> > Regards,
> > Mark.
> >
> >
> >
> >
> >
> >
> > Mladen Gogala
> >
> >
> > <mgogala@adelphia. To:
> > oracle-l@xxxxxxxxxxxxx
> > net> cc:
> >
> >
> > Sent by: Subject: Re: Methods to
> > Create Smaller Test DB from Production?
> > oracle-l-bounce@fr
> >
> >
> > eelists.org
> >
> >
> >
> >
> >
> >
> >
> >
> > 02/03/2004 06:59
> >
> >
> > Please respond to
> >
> >
> > oracle-l
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> > It does exist. Take a look at Princeton Softech,
> >
> > http://www.princetonsoftech.com
> >
> > Very good tool, very good company. Alternatively, there is
> > a UK company called DataBee, which does the same thing. I don't have
> > much experience with them, but thweir DBA Tool to extract DDL from
> > an export file is excellent. You can look at them at
> >
> > http://www.databee.com
> >
> >
> > On 03/01/2004 02:54:05 PM, "Thater, William" wrote:
> > >
> > >
> > > -----Original Message-----
> > > From: Mercadante, Thomas F [mailto:thomas.mercadante@xxxxxxxxxxxxxxxxx]
> > > Sent: Monday, March 01, 2004 2:48 PM
> > > To: 'oracle-l@xxxxxxxxxxxxx'
> > > Subject: RE: Methods to Create Smaller Test DB from Production?
> > >
> > >
> > > David,
> > >
> > > Boy, this would be a great tool if it existed.
> > >
> > > I think the only way out for you is to roll-your-own. You could easily
> > > identify code tables (look-up tables) and export all of that data. But
> > the
> > > relational data (like your main parent table and all of the subsequent
> > > children records) you will probably need to move by hand - or by writing
> > a
> > > program to select, say, 10,000 master records and all of the subsequent
> > > child records. It's not an easy task, but once you've done it, it is in
> > the
> > > can - but subject to updates when new tables and relationships come
> > along.
> > >
> > > Good Luck!
> > > [Shrek]
> > >
> > > there is a product from Quest that will do that for PeopleSoft, i used it
> > on
> > > my previous gig to do just that. but i don't know if it will work with
> > > databases other than PeopleSoft.
> > > --
> > > Bill "Shrek" Thater ORACLE DBA
> > > "I'm going to work my ticket if I can..." -- Gilwell song
> > > william.thater@xxxxxxxxxxxxxxx
> > > <mailto:william.thater@xxxxxxxxxxxxxxx>
> > > ------------------------------------------------------------------------
> > > Absence is to love what wind is to fire; it extinguishes the small, it
> > > enkindles the great. - Comte de Bussy-Rabutin
> > >
> > >
> > >
> >
> > --
> > Mladen Gogala
> > Oracle DBA
> > ----------------------------------------------------------------
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > ----------------------------------------------------------------
> > To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
> > put 'unsubscribe' in the subject line.
> > --
> > Archives are at //www.freelists.org/archives/oracle-l/
> > FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
> > -----------------------------------------------------------------
> >
> >
> >
> >
> >
> >
> <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<---->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
>
> > Privileged/Confidential information may be contained in this message.
> > If you are not the addressee indicated in this message (or responsible for
> > delivery of the message to such person), you may not copy or deliver this
> > message to anyone.
> > In such a case, you should destroy this message and kindly notify the
> > sender
> > by reply e-mail or by telephone on (03) 9612-6999 or (61) 3 9612-6999.
> > Please advise immediately if you or your employer does not consent to
> > Internet e-mail for messages of this kind.
> > Opinions, conclusions and other information in this message that do not
> > relate to the official business of Transurban Infrastructure Developments
> > Limited and CityLink Melbourne Limited shall be understood as neither given
> > nor endorsed by them.
> >
> <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<---->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
>
> >
> > ----------------------------------------------------------------
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > ----------------------------------------------------------------
> > To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
> > put 'unsubscribe' in the subject line.
> > --
> > Archives are at //www.freelists.org/archives/oracle-l/
> > FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
> > -----------------------------------------------------------------
> >
>
>
> Chris Dunscombe
>
> chris@xxxxxxxxxxxxxxxxxxxxx
>
> -------------------------------------------------
> Everyone should have http://www.freedom2surf.net/
> ----------------------------------------------------------------
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> ----------------------------------------------------------------
> To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
> put 'unsubscribe' in the subject line.
> --
> Archives are at //www.freelists.org/archives/oracle-l/
> FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
> -----------------------------------------------------------------
>
--
Mladen Gogala
Oracle DBA
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
