RE: Creating a Test Company based on Live Company Files

[Dan Thomas <DThomas@xxxxxxxxxxx>]

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.
+---