RE: Data Subset Tool?

Dale,

Thanks for your reply.

Regards,

Larry G. Elkins
elkinsl_at_flash.net
214.954.1781

> -----Original Message-----
> From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of Dale Edgar
> Sent: Saturday, January 19, 2002 1:05 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: Data Subset Tool?
>
>
> Hi Larry
>
> Disclaimer: I work for Net 2000 Ltd. the authors of DataBee.
>
> >...but does anyone have
> >recommendations on a tool that will create a subset of
> production data that
> >is referentially intact? I am aware of DataBee...
>
> I don't mind telling you who the competition is - we are confident that we
> are better value both in price and functionality:-) Two other subsetting
> tools on the market are DataManager from Quest
> http://quest.com/schema_manager/ and CheckMate from BitByBit
> http://www.bitbybit.co.uk
>
> >, but it might be more cost effective to buy
> > something if the price is right. The main feature I would be
> interested in
> > is a tool that maintained the distribution characteristics of the data.
>
> DataBee is designed specifically to cope with this requirement.
> You can set
> up the rules (called an Extraction Set) based on multiple drivers. You
> could, for example, sample 10% of a table (even on ora7.x) and then put on
> other rules which pick up specific date ranges. You can also use multiple
> tables: ie get 5% of all invoices from the INVOICE table and 25 specific
> customers from the CUSTOMER table. DataBee would cheerfully get all of the
> customers to support the invoices and all of the invoices to support the
> customers. Basically the rows are adjusted until every table has the data
> required required to support all of the rest and the subset is in balance.
>
> > I know it can be built by hand
> They can but it is (as I'm sure you know) a lot of hassle - and
> it can be a
> nightmare to get the FK constraints to re-enable if you have a
> lot of them.
> An automated tool really is cost-effective. One of our customers used to
> take a week and 45 skilled DBA hours to cut a subset database - even then
> only about 200 of the 500 constraints would enable. DataBee cuts
> the subset
> in 4 hours (its a push button operation once the Extraction Set is setup)
> and all 500 constraints enable.
>
> DataBee: http://www.databee.com
>
> Cheers
> Dale Edgar
> Net 2000 Ltd.
> Dale_at_DataBee.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Larry Elkins
  INET: elkinsl_at_flash.net

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).