I have a batch file to allows me to import the Live backup into the
Training DB
It shuts down the Training App Servers
Shuts down the Training DB
Sleeps for 20 seconds
Copies the AI files
Runs RFUTIL to end after imaging
Imports the Backup.01 file (prorest)
Runs Prostrct Repair to update the path to the Training AI files.
Runs RFUTIL to begin after imaging
Starts the Training DB
Starts the system App server. (Here is where my question comes into
play)
At this point in the file I have issued a "pause".
During the pause, I open MS Access on my desktop that runs three update
queries from the autoexec. One query updates the company name, one
updates the path to custom reports in the PUB_Menu table, and the last
one updates the Task AppServer URL and System AppServer URL in the
PUB_SysAgent table.
After running the Access program, I go back to the server and "press any
key" to continue the batch job which:
Starts the ProcessAppServer
Starts the TaskAppServer.
It works awesome,
My question is this, I realize that if MS Access was installed on the
server , I could issue a call to the application to automate the PUB
table updates and eliminate the need for the pause command from the
batch file. Does anyone have any issues regarding installing Access on
the Vantage Server in terms of conflicts with the OpenEdge DB.
I run backup exec on this server which sits on top of a SQL db without a
problem.
Thanks in advance.
Gerard M Wadman
MCSE, MCP+I, A+, NET+
Sr. Network Systems Engineer
11A Beaver Brook Road
Littleton, MA 01460
978/486-4088 x 124
866/486-4108 (fax)
http://www.scandius.com/
This e-mail is for the use of the intended recipient(s) only. If you
have received this e-mail in error, please notify the sender immediately
and then delete it. If you are not the intended recipient, you must not
use, disclose or distribute this e-mail without the author's prior
permission. We have taken precautions to minimize the risk of
transmitting software viruses, but we advise you to carry out your own
virus checks on any attachment to this message. We do not accept
liability for any loss or damage caused by software viruses
[Non-text portions of this message have been removed]
Training DB
It shuts down the Training App Servers
Shuts down the Training DB
Sleeps for 20 seconds
Copies the AI files
Runs RFUTIL to end after imaging
Imports the Backup.01 file (prorest)
Runs Prostrct Repair to update the path to the Training AI files.
Runs RFUTIL to begin after imaging
Starts the Training DB
Starts the system App server. (Here is where my question comes into
play)
At this point in the file I have issued a "pause".
During the pause, I open MS Access on my desktop that runs three update
queries from the autoexec. One query updates the company name, one
updates the path to custom reports in the PUB_Menu table, and the last
one updates the Task AppServer URL and System AppServer URL in the
PUB_SysAgent table.
After running the Access program, I go back to the server and "press any
key" to continue the batch job which:
Starts the ProcessAppServer
Starts the TaskAppServer.
It works awesome,
My question is this, I realize that if MS Access was installed on the
server , I could issue a call to the application to automate the PUB
table updates and eliminate the need for the pause command from the
batch file. Does anyone have any issues regarding installing Access on
the Vantage Server in terms of conflicts with the OpenEdge DB.
I run backup exec on this server which sits on top of a SQL db without a
problem.
Thanks in advance.
Gerard M Wadman
MCSE, MCP+I, A+, NET+
Sr. Network Systems Engineer
11A Beaver Brook Road
Littleton, MA 01460
978/486-4088 x 124
866/486-4108 (fax)
http://www.scandius.com/
This e-mail is for the use of the intended recipient(s) only. If you
have received this e-mail in error, please notify the sender immediately
and then delete it. If you are not the intended recipient, you must not
use, disclose or distribute this e-mail without the author's prior
permission. We have taken precautions to minimize the risk of
transmitting software viruses, but we advise you to carry out your own
virus checks on any attachment to this message. We do not accept
liability for any loss or damage caused by software viruses
[Non-text portions of this message have been removed]