Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Methods to Create Smaller Test DB from Production?
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
> > -----------------------------------------------------------------
> >
> >
> >
> >
> >
> >
>
<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<---->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<---->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<---->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<---->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
Chris Dunscombe
chris_at_thedunscombes.f2s.com
-- 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