Self Service Test DB refresh

I just LOL’d here in my cubicle. 

 

Sarah Cooley

Database Analyst

Lube-Power, Inc.

PH:  586-247-6500 Ext. 258

scooley@...

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Tuesday, February 03, 2015 12:03 PM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] Re: Self Service Test DB refresh

 

 

So your saying there is a chance J…….

 

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Tuesday, February 03, 2015 11:51 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Self Service Test DB refresh

 

 

Here, I'll help you:  "This is impossible to do in Progress."  Can't be done.  Walk away.  You can only do it with the Self-Service Progress Database Refresh Module.  I think Epicor sells it for $14,000 per seat.  And you need to buy a minimum of 3 seats.  

 

:-)

 

 

The information contained in this e-mail message is intended only for the use of the individual or entity named above. If the reader of this message is not the intended recipient, or is not the employee or agent responsible for delivering it to the intended recipient, you are hereby notified that any dissemination, distribution, or copying of this communication is strictly prohibited. If you have received this message in error, please notify Ferguson Perforating immediately by telephone or reply by e-mail and then promptly delete the message. Thank-you.

I am being asked to allow a user to refresh the test database from a backup of the production db on his own when ever he needs to. Tried talking people out of it but we all know how that goes.

I have a batch file that will delete the files out of the db\test and then restore the db from the backup location. I'm wondering if there are ways to have the bat file stop the test app servers and DB, and then restart the DB and App servers.


I'm trying to keep the user out of the Progress Explorer tool if at all possible. I know he will have to be able to go in and change ports in the system agent. 

By batch file to start the appserver :



@echo off

set DLC=E:\Epicor\OE102A

set PATH=%DLC%\BIN;%PATH%

set UserID=groupebertec\sqlsvradminbd

set AppServerEnv=Epicor905

set AppSrv1=epicor

set AppSrvPrt1=epicor



rem -user %UserID% -start < D:\Scripts\prcstr.txt



echo starting Database SchemaHolder...

rem call dbman -host %AppSrv1% -database %APPSERVERENV% -start





echo starting AppServer...

call asbman -host %AppSrv1% -name %APPSERVERENV%
-start

call asbman -host %AppSrvPrt1% -name %APPSERVERENV%Print
-start

call asbman -host %AppSrvPrt1% -name %APPSERVERENV%TaskAgent
-start

call asbman -host %AppSrvPrt1% -name %APPSERVERENV%ProcessServer
-start



rem Pause



By batch file to stop:



@echo off

set DLC=E:\Epicor\OE102A

set PATH=%DLC%\BIN;%PATH%

set UserID=groupebertec\sqlsvradminbd

set AppServerEnv=Epicor905

set AppSrv1=epicor

set AppSrvPrt1=epicor



rem -user %UserID% -start < D:\Scripts\prcstr.txt







echo starting AppServer...

call asbman -host %AppSrvPrt1% -name %APPSERVERENV%ProcessServer
-stop



call asbman -host %AppSrvPrt1% -name %APPSERVERENV%TaskAgent
-stop

call asbman -host %AppSrvPrt1% -name %APPSERVERENV%Print
-stop

call asbman -host %AppSrv1% -name %APPSERVERENV%
-stop



echo starting Database SchemaHolder...

rem call dbman -host %AppSrv1% -database %APPSERVERENV% -stop



rem Pause



*Amélie Pelletier*

*Analyste Programmeur / Program analyst*



[image: cid:image001.jpg@01CD5525.2091A820]



*230, Boulevard Nilus-Leclerc*

*L'Islet, Québec (Canada)*

*G0R 2C0*

*Téléphone: 418-247-3986 ext. 2402*

*Fax: 418-247-7925*

*amelie.pelletier@... <brigitte.savoie@...>*

*P* Est-ce nécessaire d’imprimer ce message?
*Please consider the environment before printing this email**.*





*De :* vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
*Envoyé :* 2 février 2015 16:25
*À :* vantage@yahoogroups.com
*Objet :* [Vantage] Self Service Test DB refresh





I am being asked to allow a user to refresh the test database from a backup
of the production db on his own when ever he needs to. Tried talking people
out of it but we all know how that goes.

I have a batch file that will delete the files out of the db\test and then
restore the db from the backup location. I'm wondering if there are ways to
have the bat file stop the test app servers and DB, and then restart the DB
and App servers.



I'm trying to keep the user out of the Progress Explorer tool if at all
possible. I know he will have to be able to go in and change ports in the
system agent.




[Non-text portions of this message have been removed]

How do you change the 9401 to 9431?

 

Or is the backup already have 9431 in the system agent?

 

Miguel A. Santillan

Compass Manufacturing Systems

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Monday, February 2, 2015 1:36 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Self Service Test DB refresh

 

 

By batch file to start the appserver :

@echo off

set DLC=E:\Epicor\OE102A

set PATH=%DLC%\BIN;%PATH%

set UserID=groupebertec\sqlsvradminbd

set AppServerEnv=Epicor905

set AppSrv1=epicor

set AppSrvPrt1=epicor

rem -user %UserID% -start < D:\Scripts\prcstr.txt

echo starting Database SchemaHolder...

rem call dbman -host %AppSrv1% -database %APPSERVERENV% -start

echo starting AppServer...

call asbman -host %AppSrv1% -name %APPSERVERENV%
-start

call asbman -host %AppSrvPrt1% -name %APPSERVERENV%Print
-start

call asbman -host %AppSrvPrt1% -name %APPSERVERENV%TaskAgent
-start

call asbman -host %AppSrvPrt1% -name %APPSERVERENV%ProcessServer
-start

rem Pause

By batch file to stop:

@echo off

set DLC=E:\Epicor\OE102A

set PATH=%DLC%\BIN;%PATH%

set UserID=groupebertec\sqlsvradminbd

set AppServerEnv=Epicor905

set AppSrv1=epicor

set AppSrvPrt1=epicor

rem -user %UserID% -start < D:\Scripts\prcstr.txt

echo starting AppServer...

call asbman -host %AppSrvPrt1% -name %APPSERVERENV%ProcessServer
-stop

call asbman -host %AppSrvPrt1% -name %APPSERVERENV%TaskAgent
-stop

call asbman -host %AppSrvPrt1% -name %APPSERVERENV%Print
-stop

call asbman -host %AppSrv1% -name %APPSERVERENV%
-stop

echo starting Database SchemaHolder...

rem call dbman -host %AppSrv1% -database %APPSERVERENV% -stop

rem Pause

*Amélie Pelletier*

*Analyste Programmeur / Program analyst*

[image: cid:image001.jpg@01CD5525.2091A820]

*230, Boulevard Nilus-Leclerc*

*L'Islet, Québec (Canada)*

*G0R 2C0*

*Téléphone: 418-247-3986 ext. 2402*

*Fax: 418-247-7925*

*amelie.pelletier@... <brigitte.savoie@...>*

*P* Est-ce nécessaire d’imprimer ce message?
*Please consider the environment before printing this email**.*

*De :* vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
*Envoyé :* 2 février 2015 16:25
*À :* vantage@yahoogroups.com
*Objet :* [Vantage] Self Service Test DB refresh

I am being asked to allow a user to refresh the test database from a backup
of the production db on his own when ever he needs to. Tried talking people
out of it but we all know how that goes.

I have a batch file that will delete the files out of the db\test and then
restore the db from the backup location. I'm wondering if there are ways to
have the bat file stop the test app servers and DB, and then restart the DB
and App servers.

I'm trying to keep the user out of the Progress Explorer tool if at all
possible. I know he will have to be able to go in and change ports in the
system agent.

[Non-text portions of this message have been removed]

It’s not a batch file for a backup, but only to stop the appserver and then
to restart them.. So you have to put your files between them.



*Amélie Pelletier*

*Analyste Programmeur / Program analyst*



[image: cid:image001.jpg@01CD5525.2091A820]



*230, Boulevard Nilus-Leclerc*

*L'Islet, Québec (Canada)*

*G0R 2C0*

*Téléphone: 418-247-3986 ext. 2402*

*Fax: 418-247-7925*

*amelie.pelletier@... <brigitte.savoie@...>*

*P* Est-ce nécessaire d’imprimer ce message?
*Please consider the environment before printing this email**.*





*De :* vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
*Envoyé :* 2 février 2015 16:52
*À :* vantage@yahoogroups.com
*Objet :* RE: [Vantage] Self Service Test DB refresh





How do you change the 9401 to 9431?



Or is the backup already have 9431 in the system agent?



Miguel A. Santillan

*Compass Manufacturing Systems*



*From:* vantage@yahoogroups.com [mailto:vantage@yahoogroups.com
<vantage@yahoogroups.com>]
*Sent:* Monday, February 2, 2015 1:36 PM
*To:* vantage@yahoogroups.com
*Subject:* RE: [Vantage] Self Service Test DB refresh





By batch file to start the appserver :

@echo off

set DLC=E:\Epicor\OE102A

set PATH=%DLC%\BIN;%PATH%

set UserID=groupebertec\sqlsvradminbd

set AppServerEnv=Epicor905

set AppSrv1=epicor

set AppSrvPrt1=epicor

rem -user %UserID% -start < D:\Scripts\prcstr.txt

echo starting Database SchemaHolder...

rem call dbman -host %AppSrv1% -database %APPSERVERENV% -start

echo starting AppServer...

call asbman -host %AppSrv1% -name %APPSERVERENV%
-start

call asbman -host %AppSrvPrt1% -name %APPSERVERENV%Print
-start

call asbman -host %AppSrvPrt1% -name %APPSERVERENV%TaskAgent
-start

call asbman -host %AppSrvPrt1% -name %APPSERVERENV%ProcessServer
-start

rem Pause

By batch file to stop:

@echo off

set DLC=E:\Epicor\OE102A

set PATH=%DLC%\BIN;%PATH%

set UserID=groupebertec\sqlsvradminbd

set AppServerEnv=Epicor905

set AppSrv1=epicor

set AppSrvPrt1=epicor

rem -user %UserID% -start < D:\Scripts\prcstr.txt

echo starting AppServer...

call asbman -host %AppSrvPrt1% -name %APPSERVERENV%ProcessServer
-stop

call asbman -host %AppSrvPrt1% -name %APPSERVERENV%TaskAgent
-stop

call asbman -host %AppSrvPrt1% -name %APPSERVERENV%Print
-stop

call asbman -host %AppSrv1% -name %APPSERVERENV%
-stop

echo starting Database SchemaHolder...

rem call dbman -host %AppSrv1% -database %APPSERVERENV% -stop

rem Pause

*Amélie Pelletier*

*Analyste Programmeur / Program analyst*

[image: cid:image001.jpg@01CD5525.2091A820]

*230, Boulevard Nilus-Leclerc*

*L'Islet, Québec (Canada)*

*G0R 2C0*

*Téléphone: 418-247-3986 ext. 2402*

*Fax: 418-247-7925*

*amelie.pelletier@... <brigitte.savoie@...>*

*P* Est-ce nécessaire d’imprimer ce message?
*Please consider the environment before printing this email**.*

*De :* vantage@yahoogroups.com [mailto:vantage@yahoogroups.com
<vantage@yahoogroups.com>]
*Envoyé :* 2 février 2015 16:25
*À :* vantage@yahoogroups.com
*Objet :* [Vantage] Self Service Test DB refresh

I am being asked to allow a user to refresh the test database from a backup
of the production db on his own when ever he needs to. Tried talking people
out of it but we all know how that goes.

I have a batch file that will delete the files out of the db\test and then
restore the db from the backup location. I'm wondering if there are ways to
have the bat file stop the test app servers and DB, and then restart the DB
and App servers.

I'm trying to keep the user out of the Progress Explorer tool if at all
possible. I know he will have to be able to go in and change ports in the
system agent.

[Non-text portions of this message have been removed]




[Non-text portions of this message have been removed]

Eeek alarms, bells and whistles are all going off in my head.
This is one of those things were u tell them out can't be done
Just sounds awful to allow an and user to copy files in /out of my prod server... Even if it's via a script

On Feb 2, 2015 4:53 PM, "Amélie Pelletier amelie.pelletier@... [vantage]" <vantage@yahoogroups.com> wrote:

Â
<div>
  
  
  <p>It’s not a batch file for a backup, but only to stop the appserver and then<br>

to restart them… So you have to put your files between them.



Amélie Pelletier



Analyste Programmeur / Program analyst



[image: cid:image001.jpg@01CD5525.2091A820]



230, Boulevard Nilus-Leclerc



L'Islet, Québec (Canada)



G0R 2C0



Téléphone: 418-247-3986 ext. 2402



Fax: 418-247-7925



amelie.pelletier@… <brigitte.savoie@…>



P Est-ce nécessaire d’imprimer ce message?

Please consider the environment before printing this email*.



De : vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]

Envoyé : 2 février 2015 16:52

À : vantage@yahoogroups.com

Objet : RE: [Vantage] Self Service Test DB refresh



How do you change the 9401 to 9431?



Or is the backup already have 9431 in the system agent?



Miguel A. Santillan



Compass Manufacturing Systems



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com

<vantage@yahoogroups.com>]

Sent: Monday, February 2, 2015 1:36 PM

To: vantage@yahoogroups.com

Subject: RE: [Vantage] Self Service Test DB refresh



By batch file to start the appserver :



@echo off



set DLC=E:\Epicor\OE102A



set PATH=%DLC%\BIN;%PATH%



set UserID=groupebertec\sqlsvradminbd



set AppServerEnv=Epicor905



set AppSrv1=epicor



set AppSrvPrt1=epicor



rem -user %UserID% -start < D:\Scripts\prcstr.txt



echo starting Database SchemaHolder…



rem call dbman -host %AppSrv1% -database %APPSERVERENV% -start



echo starting AppServer…



call asbman -host %AppSrv1% -name %APPSERVERENV%

-start



call asbman -host %AppSrvPrt1% -name %APPSERVERENV%Print

-start



call asbman -host %AppSrvPrt1% -name %APPSERVERENV%TaskAgent

-start



call asbman -host %AppSrvPrt1% -name %APPSERVERENV%ProcessServer

-start



rem Pause



By batch file to stop:



@echo off



set DLC=E:\Epicor\OE102A



set PATH=%DLC%\BIN;%PATH%



set UserID=groupebertec\sqlsvradminbd



set AppServerEnv=Epicor905



set AppSrv1=epicor



set AppSrvPrt1=epicor



rem -user %UserID% -start < D:\Scripts\prcstr.txt



echo starting AppServer…



call asbman -host %AppSrvPrt1% -name %APPSERVERENV%ProcessServer

-stop



call asbman -host %AppSrvPrt1% -name %APPSERVERENV%TaskAgent

-stop



call asbman -host %AppSrvPrt1% -name %APPSERVERENV%Print

-stop



call asbman -host %AppSrv1% -name %APPSERVERENV%

-stop



echo starting Database SchemaHolder…



rem call dbman -host %AppSrv1% -database %APPSERVERENV% -stop



rem Pause



Amélie Pelletier



Analyste Programmeur / Program analyst



[image: cid:image001.jpg@01CD5525.2091A820]



230, Boulevard Nilus-Leclerc



L'Islet, Québec (Canada)



G0R 2C0



Téléphone: 418-247-3986 ext. 2402



Fax: 418-247-7925



amelie.pelletier@… <brigitte.savoie@…>



P Est-ce nécessaire d’imprimer ce message?

Please consider the environment before printing this email*.




De : vantage@yahoogroups.com [mailto:vantage@yahoogroups.com

<vantage@yahoogroups.com>]

Envoyé : 2 février 2015 16:25

À : vantage@yahoogroups.com

Objet : [Vantage] Self Service Test DB refresh



I am being asked to allow a user to refresh the test database from a backup

of the production db on his own when ever he needs to. Tried talking people

out of it but we all know how that goes.



I have a batch file that will delete the files out of the db\test and then

restore the db from the backup location. I'm wondering if there are ways to

have the bat file stop the test app servers and DB, and then restart the DB

and App servers.



I'm trying to keep the user out of the Progress Explorer tool if at all

possible. I know he will have to be able to go in and change ports in the

system agent.



[Non-text portions of this message have been removed]



[Non-text portions of this message have been removed]


</div>
 


<div style="color:#fff;min-height:0;"></div>

I have a separate box setup for running out test out of. It was a small investment. I have a script that restores the backup from our live server to my test server, runs an update command that corrects the system agent ports, changes the manager password to manager, renames the company name with ***TEST*** in front and ending with “today’s” date, restarts the progress appservers, and then it’s all set to go. No risk to production and they get what they need.  Invest in a separate box for test if you’re going to do this that’s the key. Biggest reason being, you can script it and hope it’s safe, but if something goes up in smoke now you’re dealing with fixing your production box even if the db and all is still safe and sound you might incur downtime.

 

Joshua Giese

CIO

 

Direct:     920.593.8299

IT Dept:   920.437.6400 Ext. 337

Site ID:    27450-E905702A-SQL64

Wisconsin Converting, Inc.

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Monday, February 2, 2015 4:00 PM
To: Vantage
Subject: RE: [Vantage] Self Service Test DB refresh

 

 

Eeek alarms, bells and whistles are all going off in my head.
This is one of those things were u tell them out can't be done
Just sounds awful to allow an and user to copy files in /out of my prod server... Even if it's via a script

On Feb 2, 2015 4:53 PM, "Amélie Pelletier amelie.pelletier@... [vantage]" <vantage@yahoogroups.com> wrote:

 

It’s not a batch file for a backup, but only to stop the appserver and then
to restart them.. So you have to put your files between them.

*Amélie Pelletier*

*Analyste Programmeur / Program analyst*

[image: cid:image001.jpg@01CD5525.2091A820]

*230, Boulevard Nilus-Leclerc*

*L'Islet, Québec (Canada)*

*G0R 2C0*

*Téléphone: 418-247-3986 ext. 2402*

*Fax: 418-247-7925*

*amelie.pelletier@... <brigitte.savoie@...>*

*P* Est-ce nécessaire d’imprimer ce message?
*Please consider the environment before printing this email**.*

*De :* vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
*Envoyé :* 2 février 2015 16:52
*À :* vantage@yahoogroups.com
*Objet :* RE: [Vantage] Self Service Test DB refresh

How do you change the 9401 to 9431?

Or is the backup already have 9431 in the system agent?

Miguel A. Santillan

*Compass Manufacturing Systems*

*From:* vantage@yahoogroups.com [mailto:vantage@yahoogroups.com
<vantage@yahoogroups.com>]
*Sent:* Monday, February 2, 2015 1:36 PM
*To:* vantage@yahoogroups.com
*Subject:* RE: [Vantage] Self Service Test DB refresh

By batch file to start the appserver :

@echo off

set DLC=E:\Epicor\OE102A

set PATH=%DLC%\BIN;%PATH%

set UserID=groupebertec\sqlsvradminbd

set AppServerEnv=Epicor905

set AppSrv1=epicor

set AppSrvPrt1=epicor

rem -user %UserID% -start < D:\Scripts\prcstr.txt

echo starting Database SchemaHolder...

rem call dbman -host %AppSrv1% -database %APPSERVERENV% -start

echo starting AppServer...

call asbman -host %AppSrv1% -name %APPSERVERENV%
-start

call asbman -host %AppSrvPrt1% -name %APPSERVERENV%Print
-start

call asbman -host %AppSrvPrt1% -name %APPSERVERENV%TaskAgent
-start

call asbman -host %AppSrvPrt1% -name %APPSERVERENV%ProcessServer
-start

rem Pause

By batch file to stop:

@echo off

set DLC=E:\Epicor\OE102A

set PATH=%DLC%\BIN;%PATH%

set UserID=groupebertec\sqlsvradminbd

set AppServerEnv=Epicor905

set AppSrv1=epicor

set AppSrvPrt1=epicor

rem -user %UserID% -start < D:\Scripts\prcstr.txt

echo starting AppServer...

call asbman -host %AppSrvPrt1% -name %APPSERVERENV%ProcessServer
-stop

call asbman -host %AppSrvPrt1% -name %APPSERVERENV%TaskAgent
-stop

call asbman -host %AppSrvPrt1% -name %APPSERVERENV%Print
-stop

call asbman -host %AppSrv1% -name %APPSERVERENV%
-stop

echo starting Database SchemaHolder...

rem call dbman -host %AppSrv1% -database %APPSERVERENV% -stop

rem Pause

*Amélie Pelletier*

*Analyste Programmeur / Program analyst*

[image: cid:image001.jpg@01CD5525.2091A820]

*230, Boulevard Nilus-Leclerc*

*L'Islet, Québec (Canada)*

*G0R 2C0*

*Téléphone: 418-247-3986 ext. 2402*

*Fax: 418-247-7925*

*amelie.pelletier@... <brigitte.savoie@...>*

*P* Est-ce nécessaire d’imprimer ce message?
*Please consider the environment before printing this email**.*

*De :* vantage@yahoogroups.com [mailto:vantage@yahoogroups.com
<vantage@yahoogroups.com>]
*Envoyé :* 2 février 2015 16:25
*À :* vantage@yahoogroups.com
*Objet :* [Vantage] Self Service Test DB refresh

I am being asked to allow a user to refresh the test database from a backup
of the production db on his own when ever he needs to. Tried talking people
out of it but we all know how that goes.

I have a batch file that will delete the files out of the db\test and then
restore the db from the backup location. I'm wondering if there are ways to
have the bat file stop the test app servers and DB, and then restart the DB
and App servers.

I'm trying to keep the user out of the Progress Explorer tool if at all
possible. I know he will have to be able to go in and change ports in the
system agent.

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]

Should have qualified that it's a progress install. Thought  saw something about SQL in one of the command lines. Will this work on Progress only install? 

You can do all the same things in progress it’s just different and/or harder J

 

Joshua Giese

CIO

 

Direct:     920.593.8299

IT Dept:   920.437.6400 Ext. 337

Site ID:    27450-E905702A-SQL64

Wisconsin Converting, Inc.

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Tuesday, February 3, 2015 8:19 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Self Service Test DB refresh

 

 

Should have qualified that it's a progress install. Thought  saw something about SQL in one of the command lines. Will this work on Progress only install? 

Here, I'll help you:  "This is impossible to do in Progress."  Can't be done.  Walk away.  You can only do it with the Self-Service Progress Database Refresh Module.  I think Epicor sells it for $14,000 per seat.  And you need to buy a minimum of 3 seats.  

:-)


So your saying there is a chance J…….

 

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Tuesday, February 03, 2015 11:51 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Self Service Test DB refresh

 

 

Here, I'll help you:  "This is impossible to do in Progress."  Can't be done.  Walk away.  You can only do it with the Self-Service Progress Database Refresh Module.  I think Epicor sells it for $14,000 per seat.  And you need to buy a minimum of 3 seats.  

 

:-)

 

 

The information contained in this e-mail message is intended only for the use of the individual or entity named above. If the reader of this message is not the intended recipient, or is not the employee or agent responsible for delivering it to the intended recipient, you are hereby notified that any dissemination, distribution, or copying of this communication is strictly prohibited. If you have received this message in error, please notify Ferguson Perforating immediately by telephone or reply by e-mail and then promptly delete the message. Thank-you.