Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Methods to Create Smaller Test DB from Production?

Re: Methods to Create Smaller Test DB from Production?

From: <chris_at_thedunscombes.f2s.com>
Date: Wed, 3 Mar 2004 09:09:37 +0000
Message-ID: <1078304977.4045a0d116c91@webmail.freedom2surf.net>


Mark (& Mladen),  

Thanks for the pricing info. BTW for those interested DataBee is 7,500 per seat so it looks like both are in the same ballpark pricewise but DataBee the more expensive.  

Thanks,  

Chris    

Quoting Mark Richard <mrichard_at_transurban.com.au>:  

>
>
>
>
> Chris,
>
> I don't actually have access to pricing as the product was purchased before
> I arrived here. To give you a ballpark figure though, when purchased a one
> seat licence was less than $AU10,000 (perhaps $US6,000 when purchased - but
> the Aussie dollar is moving). We are only licenced for Oracle - I believe
> each database technology you wish to connect to introduces another cost.
>
> If you need a starting point to contact the company you could try Nicole
> Cadet (ncadet_at_princetonsoftech.com). Tell her I sent you. She will either
> be able to help you or pass you on to someone who can depending on the
> region of the world you are from.
>
> Regards,
> Mark.
>
>
>
>
>
> chris_at_thedunscombe
>
> s.f2s.com To:
> oracle-l_at_freelists.org
> Sent by: cc:
>
> oracle-l-bounce_at_fr Subject: Re: Methods to
> Create Smaller Test DB from Production?
> eelists.org
>
>
>
>
>
> 02/03/2004 20:27
>
> Please respond to
>
> oracle-l
>
>
>
>
>
>
>
>
>
> 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_at_transurban.com.au>:
>
> >
> >
> >
> >
> > 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_at_adelphia. To:
> > oracle-l_at_freelists.org
>
> > net> cc:
>
> >
> > Sent by: Subject: Re: Methods to
> > Create Smaller Test DB from Production?
> > oracle-l-bounce_at_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_at_labor.state.ny.us]
>
> > > Sent: Monday, March 01, 2004 2:48 PM
> > > To: 'oracle-l_at_freelists.org'
> > > 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_at_carrier.utc.com
> > > <mailto:william.thater_at_carrier.utc.com>
> > >
> ------------------------------------------------------------------------
> > > 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_at_freelists.org
> > put 'unsubscribe' in the subject line.
> > --
> > Archives are at http://www.freelists.org/archives/oracle-l/
> > FAQ is at http://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_at_freelists.org
> > put 'unsubscribe' in the subject line.
> > --
> > Archives are at http://www.freelists.org/archives/oracle-l/
> > FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
> > -----------------------------------------------------------------
> >
>
>
> Chris Dunscombe
>
> chris_at_thedunscombes.f2s.com
>
> -------------------------------------------------
> 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_at_freelists.org
> put 'unsubscribe' in the subject line.
> --
> Archives are at http://www.freelists.org/archives/oracle-l/
> FAQ is at http://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_at_freelists.org
> put 'unsubscribe' in the subject line.
> --
> Archives are at http://www.freelists.org/archives/oracle-l/
> FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
> -----------------------------------------------------------------
>
   

Chris Dunscombe  

chris_at_thedunscombes.f2s.com



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_at_freelists.org put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Received on Wed Mar 03 2004 - 03:07:45 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US