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@xxxxxxxxxxxxxxxxx>: > > > > > 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@xxxxxxxxxxxxxxxxxxxx). 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@thedunscombe > > s.f2s.com To: > oracle-l@xxxxxxxxxxxxx > Sent by: cc: > > oracle-l-bounce@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@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 > ----------------------------------------------------------------- > > > > > > <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<---->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> > 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 -----------------------------------------------------------------