Refresh Test Database (Automatically) LES TINGL EY

Yahoo Archive
1
I am interested in the progress explorer version of this stuff.

Thanks

Mercer Sisson

-----Original Message-----
From: Troy Funte [mailto:tfunte@...]
Sent: Friday, April 05, 2002 9:28 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Re: Refresh Test Database (Automatically) LES TINGLEY


I forgot to give due credit to another bloke, Alan Williams. Thanks for
your contribution as well, Alan.

Troy Funte
Liberty Electronics

----- Original Message -----
From: Troy Funte
To: vantage@yahoogroups.com
Sent: Friday, April 05, 2002 1:34 AM
Subject: Re: [Vantage] Re: Refresh Test Database (Automatically) LES
TINGLEY


Scott, Les, and the peanut gallery,

I finally got around to testing this automated refresh of Test
Database. After looking at samples from several people I finally landed on
the solution below. (I used Procontrol, remember, so this may be different
if you use Progress Explorer. I don't know.) For some odd reason, certain
batch files would die after the restore part without restarting the test
database again. The batch file below seems to do the whole process without
stopping after the restore.

Tester's NOTES:
A. the "y.txt" file reference refers to a text file that simply has the
letter y ("y") in it along with a Carriage Return. This supplies the
necessary answer "y" to the question of whether you want to stop the
database in one instance, and overwrite the current database in another
instance.
B. I have a 'rem' statement in the section to do a backup online of the
live database, but I didn't need it (or test it) so I left it there for
future reference. Someone can try it if they want to.
C. Credit goes to Les Tingley, Terry Williams, and Jay Erickson for pieces
of the puzzle.
D. I received some bathc files from Jay Erickson that should work for
Progress Explorer (including updating the icons in the interface) if anyone
is interested.

Troy Funte
Liberty Electronics


Rem ------------- Start of Batch File 51testud.bat -------------------
echo off
Set dlc=e:\epic51\Progress

call e:\epic51\progress\bin\proshut.bat d:\epic51\vantage -F <
e:\epic51\Y.txt > e:\epic51\test2db_log.wri

echo. >> e:\epic51\test2db_log.wri
echo. Shutdown of test2 DB Complete. >> e:\epic51\test2db_log.wri
echo.=================================== >> e:\epic51\test2db_log.wri
echo. >> e:\epic51\test2db_log.wri

rem call e:\epic51\progress\bin\probkup online d:\epic51\vantage
e:\epic51\test2\backup.1 >> e:\epic51\test2db_log.wri

echo. Backup of Live DB Complete. >> e:\epic51\test2db_log.wri
echo.=================================== >> e:\epic51\test2db_log.wri
echo. >> e:\epic51\test2db_log.wri

call e:\epic51\progress\bin\prorest d:\epic51\vantage d:\back51am.1 <
e:\epic51\Y.txt >> e:\epic51\test2db_log.wri

echo. >> e:\epic51\test2db_log.wri
echo. Restore of test2 DB Complete. >> e:\epic51\test2db_log.wri
echo.=================================== >> e:\epic51\test2db_log.wri

e:\epic51\progress\bin\_mprosrv.exe d:\epic51\vantage -by -N TCP -H
localhost -S epic51

echo. >> e:\epic51\test2db_log.wri
echo. *** DATABASE STARTED *** >> e:\epic51\test2db_log.wri
exit
rem ------------end of batch file 51testud.bat
--------------------------------------



----- Original Message -----
From: Lepley, Scott A.
To: 'vantage@yahoogroups.com'
Sent: Thursday, April 04, 2002 1:31 PM
Subject: RE: [Vantage] Re: Refresh Test Database (Automatically) LES
TINGLEY


Troy,

Any luck with your test?

Regards,
Scott

-----Original Message-----
From: Troy Funte [mailto:tfunte@...]
Sent: Monday, April 01, 2002 9:48 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Re: Refresh Test Database (Automatically) LES
TINGLEY

Les,
I got the files, but haven't had a chance to try it yet. I'm hoping
tomorrow when I can get on our test database I'll try it out. I'll be
sure
to let ya'll know.

Troy Funte
Liberty Electronics

----- Original Message -----
From: Les Tingley
To: vantage@yahoogroups.com
Sent: Monday, April 01, 2002 3:09 PM
Subject: RE: [Vantage] Re: Refresh Test Database (Automatically) LES
TINGLEY


Hi Robert,
I supplied Troy with Bat files to stop and start his services, which
seemed
to be the way that he wanted to proceed with this. I haven't automated
my
Test DB yet, I thought I would wait and see how he made out. Troy are
you
out there? - Les

> -----Original Message-----
> From: r_van_hoy [SMTP:r_van_hoy@...]
> Sent: Monday, April 01, 2002 2:59 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: Refresh Test Database (Automatically)
LES
> TINGLEY
>
> Hi Les Tingley
> I could use some help with batch files to back up our test data base
> Thanks
>
> Robert Van Hoy
> email: robert.e.vanhoy@...



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


Yahoo! Groups Sponsor
ADVERTISEMENT




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/.
<http://groups.yahoo.com/group/vantage/files/.>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<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
<http://groups.yahoo.com/group/vantage/links>

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



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


Yahoo! Groups Sponsor
ADVERTISEMENT




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/.
<http://groups.yahoo.com/group/vantage/files/.>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<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
<http://groups.yahoo.com/group/vantage/links>

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



[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/.
<http://groups.yahoo.com/group/vantage/files/.>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<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
<http://groups.yahoo.com/group/vantage/links>

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .




[Non-text portions of this message have been removed]
2
Hi Robert,
I supplied Troy with Bat files to stop and start his services, which seemed
to be the way that he wanted to proceed with this. I haven't automated my
Test DB yet, I thought I would wait and see how he made out. Troy are you
out there? - Les

> -----Original Message-----
> From: r_van_hoy [SMTP:r_van_hoy@...]
> Sent: Monday, April 01, 2002 2:59 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: Refresh Test Database (Automatically) LES
> TINGLEY
>
> Hi Les Tingley
> I could use some help with batch files to back up our test data base
> Thanks
>
> Robert Van Hoy
> email: robert.e.vanhoy@...
>
>
>
>
> 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
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
3
Troy,

Any luck with your test?

Regards,
Scott

-----Original Message-----
From: Troy Funte [mailto:tfunte@...]
Sent: Monday, April 01, 2002 9:48 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Re: Refresh Test Database (Automatically) LES TINGLEY

Les,
I got the files, but haven't had a chance to try it yet. I'm hoping
tomorrow when I can get on our test database I'll try it out. I'll be sure
to let ya'll know.

Troy Funte
Liberty Electronics

----- Original Message -----
From: Les Tingley
To: vantage@yahoogroups.com
Sent: Monday, April 01, 2002 3:09 PM
Subject: RE: [Vantage] Re: Refresh Test Database (Automatically) LES
TINGLEY


Hi Robert,
I supplied Troy with Bat files to stop and start his services, which
seemed
to be the way that he wanted to proceed with this. I haven't automated my
Test DB yet, I thought I would wait and see how he made out. Troy are you
out there? - Les

> -----Original Message-----
> From: r_van_hoy [SMTP:r_van_hoy@...]
> Sent: Monday, April 01, 2002 2:59 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: Refresh Test Database (Automatically) LES
> TINGLEY
>
> Hi Les Tingley
> I could use some help with batch files to back up our test data base
> Thanks
>
> Robert Van Hoy
> email: robert.e.vanhoy@...



[Non-text portions of this message have been removed]
4
Troy, try these:

http://www.progress.com/services/support/cgi-bin/techweb-kbase.cgi/dispentry
.p?kbid=16683
<http://www.progress.com/services/support/cgi-bin/techweb-kbase.cgi/dispentr
y.p?kbid=16683&keywords=5180&wintype=kbwindow>
&keywords=5180&wintype=kbwindow
http://www.progress.com/services/support/cgi-bin/techweb-kbase.cgi/dispentry
.p?kbid=21234
<http://www.progress.com/services/support/cgi-bin/techweb-kbase.cgi/dispentr
y.p?kbid=21234&keywords=5180&wintype=kbwindow>
&keywords=5180&wintype=kbwindow

Hope this helps,

Ted Kitch
ted@...

-----Original Message-----
From: Troy Funte [mailto:tfunte@...]
Sent: Friday, April 05, 2002 10:43 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Re: Refresh Test Database (Automatically) LES TINGLEY

Question to Window2000Server or Progress Experts...

The batch file below works fine on my Win200Pro laptop. But when I run it
on our live server for our test database, I get the following message during
the SHUTDOWN phase of the batch file:

11:40:04 BROKER : Event Logger error 997: Could not post a
'VANTAGE_PROGRESS' event to the Event Viewer. (5180)


If I clear the event viewer, it will run the next time, but not the time
after that (have to clear the event viewer again). I don't think the Event
viewer is not full because it only has a couple hundred entries, whereas it
can hold many more than that.

Any ideas?

----- Original Message -----
From: Troy Funte
To: vantage@yahoogroups.com
Sent: Friday, April 05, 2002 1:34 AM
Subject: Re: [Vantage] Re: Refresh Test Database (Automatically) LES
TINGLEY


Scott, Les, and the peanut gallery,

I finally got around to testing this automated refresh of Test
Database. After looking at samples from several people I finally landed on
the solution below. (I used Procontrol, remember, so this may be different
if you use Progress Explorer. I don't know.) For some odd reason, certain
batch files would die after the restore part without restarting the test
database again. The batch file below seems to do the whole process without
stopping after the restore.

Tester's NOTES:
A. the "y.txt" file reference refers to a text file that simply has the
letter y ("y") in it along with a Carriage Return. This supplies the
necessary answer "y" to the question of whether you want to stop the
database in one instance, and overwrite the current database in another
instance.
B. I have a 'rem' statement in the section to do a backup online of the
live database, but I didn't need it (or test it) so I left it there for
future reference. Someone can try it if they want to.
C. Credit goes to Les Tingley, Terry Williams, and Jay Erickson for pieces
of the puzzle.
D. I received some bathc files from Jay Erickson that should work for
Progress Explorer (including updating the icons in the interface) if anyone
is interested.

Troy Funte
Liberty Electronics


Rem ------------- Start of Batch File 51testud.bat -------------------
echo off
Set dlc=e:\epic51\Progress

call e:\epic51\progress\bin\proshut.bat d:\epic51\vantage -F <
e:\epic51\Y.txt > e:\epic51\test2db_log.wri

echo. >> e:\epic51\test2db_log.wri
echo. Shutdown of test2 DB Complete. >> e:\epic51\test2db_log.wri
echo.=================================== >> e:\epic51\test2db_log.wri
echo. >> e:\epic51\test2db_log.wri

rem call e:\epic51\progress\bin\probkup online d:\epic51\vantage
e:\epic51\test2\backup.1 >> e:\epic51\test2db_log.wri

echo. Backup of Live DB Complete. >> e:\epic51\test2db_log.wri
echo.=================================== >> e:\epic51\test2db_log.wri
echo. >> e:\epic51\test2db_log.wri

call e:\epic51\progress\bin\prorest d:\epic51\vantage d:\back51am.1 <
e:\epic51\Y.txt >> e:\epic51\test2db_log.wri

echo. >> e:\epic51\test2db_log.wri
echo. Restore of test2 DB Complete. >> e:\epic51\test2db_log.wri
echo.=================================== >> e:\epic51\test2db_log.wri

e:\epic51\progress\bin\_mprosrv.exe d:\epic51\vantage -by -N TCP -H
localhost -S epic51

echo. >> e:\epic51\test2db_log.wri
echo. *** DATABASE STARTED *** >> e:\epic51\test2db_log.wri
exit
rem ------------end of batch file 51testud.bat
--------------------------------------



----- Original Message -----
From: Lepley, Scott A.
To: 'vantage@yahoogroups.com'
Sent: Thursday, April 04, 2002 1:31 PM
Subject: RE: [Vantage] Re: Refresh Test Database (Automatically) LES
TINGLEY


Troy,

Any luck with your test?

Regards,
Scott

-----Original Message-----
From: Troy Funte [mailto:tfunte@...]
Sent: Monday, April 01, 2002 9:48 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Re: Refresh Test Database (Automatically) LES
TINGLEY

Les,
I got the files, but haven't had a chance to try it yet. I'm hoping
tomorrow when I can get on our test database I'll try it out. I'll be
sure
to let ya'll know.

Troy Funte
Liberty Electronics

----- Original Message -----
From: Les Tingley
To: vantage@yahoogroups.com
Sent: Monday, April 01, 2002 3:09 PM
Subject: RE: [Vantage] Re: Refresh Test Database (Automatically) LES
TINGLEY


Hi Robert,
I supplied Troy with Bat files to stop and start his services, which
seemed
to be the way that he wanted to proceed with this. I haven't automated
my
Test DB yet, I thought I would wait and see how he made out. Troy are
you
out there? - Les

> -----Original Message-----
> From: r_van_hoy [SMTP:r_van_hoy@...]
> Sent: Monday, April 01, 2002 2:59 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: Refresh Test Database (Automatically)
LES
> TINGLEY
>
> Hi Les Tingley
> I could use some help with batch files to back up our test data base
> Thanks
>
> Robert Van Hoy
> email: robert.e.vanhoy@...



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


Yahoo! Groups Sponsor
ADVERTISEMENT




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/.
<http://groups.yahoo.com/group/vantage/files/>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<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
<http://groups.yahoo.com/group/vantage/links>

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



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


Yahoo! Groups Sponsor
ADVERTISEMENT




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/.
<http://groups.yahoo.com/group/vantage/files/>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<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
<http://groups.yahoo.com/group/vantage/links>

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



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





Yahoo! Groups Sponsor


ADVERTISEMENT

<http://rd.yahoo.com/M=215002.1954253.3462811.1261774/D=egroupweb/S=17050071
83:HM/A=1000239/R=0/*http:/ads.x10.com/?bHlhaG9vaG0xLmRhd=1018025143%3eM=215
002.1954253.3462811.1261774/D=egroupweb/S=1705007183:HM/A=1000239/R=1>


<http://us.adserver.yahoo.com/l?M=215002.1954253.3462811.1261774/D=egroupmai
l/S=1705007183:HM/A=1000239/rand=591882029>

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/.
<http://groups.yahoo.com/group/vantage/files/>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<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
<http://groups.yahoo.com/group/vantage/links>

Your use of Yahoo! Groups is subject to the Yahoo!
<http://docs.yahoo.com/info/terms/> Terms of Service.


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