Building a Test Environment

Yahoo Archive
1
I'm not sure of the later 8.x releases but you used to NOT be able to backup the schema holder database for Test and restore it into Pilot (for example.) There's references to the actual SQL database such that the Pilot Schema Holder would then point to the Test Database.

----- Original Message -----
From: "Brian" <brian.chandler@...>
To: <vantage@yahoogroups.com>
Sent: Thursday, November 01, 2007 6:20 AM
Subject: [Vantage] Re: Building a Test Environment


I am trying to create a test environment on the same server. I
currently have Production, Pilot, Test and Training and would like
to add DEV.

It should be in the beginning at least an exact duplicate of Pilot
in it's current state. This would run on the same server. I have
already created the duplicate SQL database part but do not
completely understand how to copy and more importantly rename the
current Pilot Progress App/Data environment.


--- In vantage@yahoogroups.com, "Lauren Hellings" <LaurenH@...>
wrote:
>
> Are you looking to simply make a copy of your production database
on the
> same server, or are you trying to create an entirely separate
database
> to test service packs and patches on? They are two very different
> things.
>
> ________________________________
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf
> Of Brian
> Sent: Thursday, November 01, 2007 8:27 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Building a Test Environment
>
> Does anyone know a quick way to build a test database from a
> production database. I know how to build out the SQL side of it
but I
> am new to the Progress part and have not had any success as of yet.
>
>
>
> [Non-text portions of this message have been removed]
>




Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/links
Yahoo! Groups Links




[Non-text portions of this message have been removed]
2
Does anyone know a quick way to build a test database from a
production database. I know how to build out the SQL side of it but I
am new to the Progress part and have not had any success as of yet.
3
Summary: PG How to copy your database to a different folder or
directory

Book: Support Solutions

Page: 5881MPS



There are three methods to copy your database to a different folder or
directory.



They are:

1) Prorest (Restore of your online backup file).

2) Procopy of your live database

3) OS copy with Prostrct Repair.



We recommend using the Progress Prorest or Procopy utility. This copies
the database safely to the new target folder and makes it ready for use
immediately. The third option of using Windows Explorer to copy the
database had the potential of destroying both the copy and the source
database if the database is not shutdown. Then once the copy is made, a
repair command must be issued.



When copying the database is done, refer the last section of this
document, Restarting Your Database
===================================================================



HOW TO USE PROREST:

=====================

1) Open Progress Explorer and STOP the Appservers, and then the
database you wish to overwrite. In this example we will use the
"MfgSys80" database.



Open the Appservers and Right click each Mfgsys80 Appserver and stop
them. Then open Databases, and on the MfgSys80 database and select
"Stop".



2) Go to [START] --> Programs --> OpenEdge 10b --> Proenv



3) At the Proenv prompt, type the word: "prompt" and press enter.



4) Next change directories to the target folder where you want to
restore your MfgSys backup copy. The example uses the training folder.



E:\EPICOR\TRAIN80\DB>



5) The following command is an example of restoring the backup.1 file
from the F:\Backup folder to the training database directory. The
syntax is:



prorest mfgsys e:\backup\backup.1





If a database exists in the folder, you will be prompted a
question "Do you wish to Overwrite?" answer "Y" for yes.



When the process finishes, the prompt will be returned to the
screen.



===================================================================



HOW TO USE PROCOPY:

===================



1) Open Progress Explorer and STOP the Appservers, and then the
database you wish to copy from. In this example we will use the
"MfgSys80" database as the database to copy from.



Open the Appservers and Right click each Mfgsys80 Appserver and stop
them. Then open Databases, and on the MfgSys80 database and select
"Stop".



Open Progress Explorer and STOP the database you wish to overwrite. In
this example we will use the "Mfgtrain80" database. Open the Appservers
and Right click each MfgTrain80 Appserver and stop them. Right click on
the Mfgtrain80 database and select "Stop".



2) Go to [START] --> Programs --> OpenEdge 10B --> Proenv



3) At the Proenv prompt, type the word: "prompt" and press enter.



4) Next change directories to the target folder where you want the
copy to be placed. This example uses the training folder.



E:\EPICOR\TRAIN80\DB>



5) The following command is an example of copying the 'live' database
to the training database directory.

The syntax is: procopy c:\epicor\mfgsys80\db\mfgsys mfgsys



This command will copy the database into the folder where you are
standing or where ever your prompt is set at.





===================================================================



HOW TO USE an OS COPY and then PROSTRCT REPAIR:

================================================



1) Make sure the source database is shutdown. Open Progress Explorer
and STOP the Appservers, and then the database you wish to copy from.
In this example we will use the "MfgSys80" database as the database to
copy from.



Open the Appservers and Right click each Mfgsys80 Appserver and stop
them. Then open Databases, and on the MfgSys80 database and select
"Stop".



WARNING! Failure to do this will result in a damaged copy and possibly
a damaged source database as



2) Open Windows Explorer and locate the source database. For this
example a copy of the \Epicor\MfgSys80\Db\MfgSys database will be copied
to the \Epicor\Train80\db folder.

Using the <CTRL> key, click on 4 files: MfgSys.d1, MfgSys.b1, MfgSys.db
and MfgSys.st. Copy and paste these 4 files to your Train80\db folder.



3) Next, double click on the copied MfgSys.st file in the target folder
and open it with notepad. Note the path designation for each extent.
If the path that precedes the is a dot or period (.) close the
vantage.st. IF, the path has a full path designation as in the example
below, change the path to reflect the new directory.



BEFORE:



#

b c:\epicor\mfgsys80\db\mfgsys.b1

#

d "Schema Area":6,32 c:\epicor\mfgsys80\db \mfgsys.d1



AFTER:



#

b c:\epicor\train80\db\mfgsys.b1

#

d "Schema Area":6,32 c:\epicor\train80\db\mfgsys.d1





4) Go to [START] --> Programs --> OpenEdge 10B --> Proenv



5) At the Proenv prompt, type the word: "prompt" and press enter.



6) Next change directories to the Training or target folder where you
just copied the files to.



C:\EPICOR\TRAIN80\DB>



7) The following command will repair or reset the MfgSys.db to run from
the new location.

The syntax is: prostrct repair mfgsys





*** Change drive letters and directory paths when necessary to reflect
your configuration or your version.



===================================================================



RESTARTING YOUR DATABASE

================================================



After the database has been copied, the source and target databases will
need to be restarted.



1) To restart the source database (MfgSys80 in our examples above),
open the Progress Explorer Tool. Go to Databases, right-click on the
MfgSys80 database and click Start. Then, go the AppServers, right-click
on each MfgSys80 AppServer and click Start. The MfgSys80 database is
now ready to be used again.



2) The configuration file for the target database (MfgTrain80 in our
examples above) will need to be updated, so that it shows the correct
location of the database file. For the MfgTrain80 DB, this file would
be:

E:\epicor\mfgsys80\server\config\mfgtrain.pf



There is a line in this file that starts with a -db. Be certain this
line points to the correct location of the MfgTrain80 DB. In our
examples, it should be:

-db E:\epicor\train80\db\mfgsys



3) To restart the target database (MfgTrain80 in our examples above),
open the Progress Explorer Tool. Go to Databases, right-click on the
MfgTrain80 database and click Start. Then, go the AppServers,
right-click on each MfgTrain80 AppServer and click Start. The
MfgTrain80 database is now ready to be used again.



*** Change drive letters and directory paths when necessary to reflect
your configuration or your version.





From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Brian
Sent: Thursday, November 01, 2007 8:27 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Building a Test Environment



Does anyone know a quick way to build a test database from a
production database. I know how to build out the SQL side of it but I
am new to the Progress part and have not had any success as of yet.





[Non-text portions of this message have been removed]
4
Were on version 6.1 Progress. We just restore our backup of the live database to the training db location.



________________________________
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Brian
Sent: Thursday, November 01, 2007 7:27 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Building a Test Environment


Does anyone know a quick way to build a test database from a
production database. I know how to build out the SQL side of it but I
am new to the Progress part and have not had any success as of yet.



[Non-text portions of this message have been removed]
5
Are you looking to simply make a copy of your production database on the
same server, or are you trying to create an entirely separate database
to test service packs and patches on? They are two very different
things.

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Brian
Sent: Thursday, November 01, 2007 8:27 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Building a Test Environment

Does anyone know a quick way to build a test database from a
production database. I know how to build out the SQL side of it but I
am new to the Progress part and have not had any success as of yet.



[Non-text portions of this message have been removed]
6
I am trying to create a test environment on the same server. I
currently have Production, Pilot, Test and Training and would like
to add DEV.

It should be in the beginning at least an exact duplicate of Pilot
in it's current state. This would run on the same server. I have
already created the duplicate SQL database part but do not
completely understand how to copy and more importantly rename the
current Pilot Progress App/Data environment.


--- In vantage@yahoogroups.com, "Lauren Hellings" <LaurenH@...>
wrote:
>
> Are you looking to simply make a copy of your production database
on the
> same server, or are you trying to create an entirely separate
database
> to test service packs and patches on? They are two very different
> things.
>
> ________________________________
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf
> Of Brian
> Sent: Thursday, November 01, 2007 8:27 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Building a Test Environment
>
> Does anyone know a quick way to build a test database from a
> production database. I know how to build out the SQL side of it
but I
> am new to the Progress part and have not had any success as of yet.
>
>
>
> [Non-text portions of this message have been removed]
>
7
> I am trying to create a test environment on the same server. I
> currently have Production, Pilot, Test and Training and would like
> to add DEV.

FWIW, I prefer to have a DEV system on a different machine. That way I can
test changes to versions of the database as well. Preferably, I would use a
virtual machine as well (like the free VMWare Server) so that is easy to roll
back any unwanted whoops, er, I mean changes.

Mark W.