Re: Creating a Test Company based on Live Company Files

It worked well for a client I once worked with. Training was meaningful and
we were able to test PTFs on real data before inflicting them on the larger
user population. Greg
----- Original Message -----
From: "Dan Thomas" <DThomas@lpw-mdi.com>
To: <JBAUSERS-L@midrange.com>
Sent: Tuesday, December 19, 2000 11:58 AM
Subject: RE: Creating a Test Company based on Live Company Files


> Is a second small server for testing not a cost effective option for most
> companies?
>
> Dan Thomas
> Sr. VP Information Systems
> MDI
> 4500 Progress Blvd.
> Louisville, KY  40218-5058
> Phone (502) 454-9013 ext. 120
> www.mdiweb.com
>
>
> -----Original Message-----
> From: Duncan, Helen (MacGas) [mailto:DuncanH2@bp.com]
> Sent: Monday, December 18, 2000 6:51 AM
> To: 'JBAUSERS-L@midrange.com'
> Subject: RE: Creating a Test Company based on Live Company Files
>
>
> Instead of using test companies on the same files as the live data, we
have
> created a duplicate set of files prefixed TST instead of OSL.  We have set
> up 2 different test environments: TSP (production test environment - which
> mimics live environment) and TSD (development test environment which
> contains changes & fixes for testing).  We have set up separate user
> profiles to access the test environments and we have written programs to
> populate the test files with cut down copies of the live files using CPYF.
> Care needs to be taken that there is no activity on the live system when
the
> test system is re-generated - otherwise the invoice & order numbers get
out
> of sync.
>
> This was quite labour-intensive to set up, but it works well.
>
> Helen
>
> > ----------
> > From: plynch@sunflowermfg.com[SMTP:plynch@sunflowermfg.com]
> > Reply To: JBAUSERS-L@midrange.com
> > Sent: 14 December 2000 20:50
> > To: JBAUSERS-L@midrange.com
> > Subject: Creating a Test Company based on Live Company Files
> >
> > Sunflower needs to syncronize the test environment with the live
> > environment on a weekly basis.
> > This need is extremely critical right now because we're testing SP3 for
> > 3.5.2b.
> >
> > Does anyone out there have, or know of, a utility that performs this
task
> > cleanly?
> >
> > Currently we have a program that runs a series of SQL statements that
does
> > most of the job but it is not clean enough or reliable enough to permit
a
> > full blown test. Part of the issue is the fact that not all files prefix
> > their company number fields with "CONO". During the copy we convert the
> > live company number to a different test company number so users are
fully
> > aware when they are in the test environment.
> >
> > We'd like to run the live and test side as close to parallel as possible
> > to
> > facilitate efficient testing of this, and subsequent, service packs.
> > Having
> > a reliable utility for this would really cut down on some of the pain of
> > uplifting.
> >
> > Patricia Lynch
> > Sunflower Mfg. Co., Inc.
> > AS/400 Applications Mgr.
> >
> > +---
> > | This is the JBA Software Users Mailing List!
> > | To submit a new message send your mail to JBAUSERS-L@midrange.com.
> > | To subscribe to this list send email to JBAUSERS-L-SUB@midrange.com.
> > | To unsubscribe from this list send email to
> > JBAUSERS-L-UNSUB@midrange.com.
> > | Questions should be directed to the list owner: doug333@aol.com.
> > +---
> >
> +---
> | This is the JBA Software Users Mailing List!
> | To submit a new message send your mail to JBAUSERS-L@midrange.com.
> | To subscribe to this list send email to JBAUSERS-L-SUB@midrange.com.
> | To unsubscribe from this list send email to
JBAUSERS-L-UNSUB@midrange.com.
> | Questions should be directed to the list owner: doug333@aol.com.
> +---
> +---
> | This is the JBA Software Users Mailing List!
> | To submit a new message send your mail to JBAUSERS-L@midrange.com.
> | To subscribe to this list send email to JBAUSERS-L-SUB@midrange.com.
> | To unsubscribe from this list send email to
JBAUSERS-L-UNSUB@midrange.com.
> | Questions should be directed to the list owner: doug333@aol.com.
> +---
>

+---
| This is the JBA Software Users Mailing List!
| To submit a new message send your mail to JBAUSERS-L@midrange.com.
| To subscribe to this list send email to JBAUSERS-L-SUB@midrange.com.
| To unsubscribe from this list send email to JBAUSERS-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: doug333@aol.com.
+---