There are a couple of very important issues in copying from the live to
the test. One is the port numbers used in the System Agent file. For
version 8.03x they are 8301 and 8303 for the live and 8321 and 8323 for
the test. These will need to be changed. The other big issue you will
run into is with ODBC reports. This is because those reports are using
a specific DSN that points to the live database. We create two copies
of every ODBC report, one for the live (*_0.rpt) and one for the test
(*_1.rpt). This also means you have to modify every custom report menu
entry when you copy from the live to the test to ensure it uses the
correct reports. I use linked tables in Microsoft Access and have a
query over the menu table that only selects the custom report entries.
I simply start Access and then do a search and replace on the Arguments
column in the Menu Table to change all of the entries. You can also
change the port numbers in Access if you like or you can do the
following to change them after copying the data:
Start the database and the Main App Server, enter Vantage, change the
port numbers in the system agent, exit Vantage, stop the main App Server
and then start all of the app servers. The reason for this is if you
start the task agent, etc. before changing the port numbers it will use
the agent from the live environment since it is using the same port
numbers.
It does matter which order things are stopped and started. The main
thing to remember is always stop the appservers before stopping the
database and always start the database before starting the appservers.
I have had to restart the machine on occasion if I did not stick with
that order.
When stopping, stop in this order.
Process Server
Task Agent
Main App Server
Database
Reverse that for starting.
I actually have scripts that I run to perform all of the above so I
don't have to worry about it. I have the scripts on the task scheduler
as disabled tasks but then I can run them whenever needed.
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Calvin Krusen
Sent: Tuesday, June 10, 2008 8:09 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Creating Test Company from Live Company
What are the exact steps to create a test company from a live
company?
We currently make a backup the live company database every night
using the progress probkup program.
I know how to restore the backup to a new location, but I'm not sure
of the steps I need to do in the Progress Exp Tool, and how to
reconfig the settings in the DB(particularly in the System Agent) to
avoid the new test company from conflicting with the live company.
And while I'm begging, what is the exact order for stopping a
Progress DB in the PET? Is it:
1) Stop the db \localhost\Databases\MfgTest803
2) Stop the Appserver \localhost\AppServer\MfgTest803
3) Stop the Appserver \localhost\AppServer\MfgTest803ProcessServer
4) Stop the Appserver \localhost\AppServer\MfgTest803Task Agent
Doe it matter which order the AppServers are stopped? And should
they be stopped before or after the Database?
Thanks,
Calvin
Charles Carden
Manager, MIS
Manitex, Inc.
Phone: 512-942-3086
Fax: 512-942-3089
DISCLAIMER:
This e-mail, including attachments, may include confidential and/or
proprietary information, and may be used only by the person or entity to
which it is addressed. If the reader of this e-mail is not the intended
recipient or his or her authorized agent, the reader is hereby notified
that any dissemination, distribution or copying of this e-mail is
prohibited. If you have received this e-mail in error, please notify the
sender by replying to this message and delete this e-mail immediately.
[Non-text portions of this message have been removed]
the test. One is the port numbers used in the System Agent file. For
version 8.03x they are 8301 and 8303 for the live and 8321 and 8323 for
the test. These will need to be changed. The other big issue you will
run into is with ODBC reports. This is because those reports are using
a specific DSN that points to the live database. We create two copies
of every ODBC report, one for the live (*_0.rpt) and one for the test
(*_1.rpt). This also means you have to modify every custom report menu
entry when you copy from the live to the test to ensure it uses the
correct reports. I use linked tables in Microsoft Access and have a
query over the menu table that only selects the custom report entries.
I simply start Access and then do a search and replace on the Arguments
column in the Menu Table to change all of the entries. You can also
change the port numbers in Access if you like or you can do the
following to change them after copying the data:
Start the database and the Main App Server, enter Vantage, change the
port numbers in the system agent, exit Vantage, stop the main App Server
and then start all of the app servers. The reason for this is if you
start the task agent, etc. before changing the port numbers it will use
the agent from the live environment since it is using the same port
numbers.
It does matter which order things are stopped and started. The main
thing to remember is always stop the appservers before stopping the
database and always start the database before starting the appservers.
I have had to restart the machine on occasion if I did not stick with
that order.
When stopping, stop in this order.
Process Server
Task Agent
Main App Server
Database
Reverse that for starting.
I actually have scripts that I run to perform all of the above so I
don't have to worry about it. I have the scripts on the task scheduler
as disabled tasks but then I can run them whenever needed.
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Calvin Krusen
Sent: Tuesday, June 10, 2008 8:09 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Creating Test Company from Live Company
What are the exact steps to create a test company from a live
company?
We currently make a backup the live company database every night
using the progress probkup program.
I know how to restore the backup to a new location, but I'm not sure
of the steps I need to do in the Progress Exp Tool, and how to
reconfig the settings in the DB(particularly in the System Agent) to
avoid the new test company from conflicting with the live company.
And while I'm begging, what is the exact order for stopping a
Progress DB in the PET? Is it:
1) Stop the db \localhost\Databases\MfgTest803
2) Stop the Appserver \localhost\AppServer\MfgTest803
3) Stop the Appserver \localhost\AppServer\MfgTest803ProcessServer
4) Stop the Appserver \localhost\AppServer\MfgTest803Task Agent
Doe it matter which order the AppServers are stopped? And should
they be stopped before or after the Database?
Thanks,
Calvin
Charles Carden
Manager, MIS
Manitex, Inc.
Phone: 512-942-3086
Fax: 512-942-3089
DISCLAIMER:
This e-mail, including attachments, may include confidential and/or
proprietary information, and may be used only by the person or entity to
which it is addressed. If the reader of this e-mail is not the intended
recipient or his or her authorized agent, the reader is hereby notified
that any dissemination, distribution or copying of this e-mail is
prohibited. If you have received this e-mail in error, please notify the
sender by replying to this message and delete this e-mail immediately.
[Non-text portions of this message have been removed]