Refresh Test Database (Automatically) LES TINGLEY

Yahoo Archive
1
Hi
I don't have these files anymore, but perhaps someone else knows the commands to start and stop the Progress Explorer from a batch file. If not, You should be able to obtain something from Epicor's excellent Tech support department.

Troy Funte
Liberty Electronics

----- Original Message -----
From: ams@...
To: vantage@yahoogroups.com
Sent: Monday, June 24, 2002 4:54 PM
Subject: RE: [Vantage] Re: Refresh Test Database (Automatically) LES TINGLEY


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]


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 the Yahoo! Terms of Service.


[Non-text portions of this message have been removed]
2
I know a number of you Vantage users keep a current copy of their database as a Test version on the side. Has anyone automated this process to do so on a daily/weekly basis?

You would need to automate the Shutdown of the database, then restore from a backup copy, then start the database back up again. It would be nice to also update the Company name with the current backup date as well.

Any ideas?

Troy Funte
Liberty Electronics



[Non-text portions of this message have been removed]
3
You might try automating it by doing a restore from the progress backup of
the live database. I also like to change my FAVORITES BAR background color
to the most annoying color I can as a reminder I'm working in another world.

-----Original Message-----
From: Troy Funte [mailto:tfunte@...]
Sent: Thursday, March 28, 2002 8:00 AM
To: Vantage
Subject: [Vantage] Refresh Test Database (Automatically)


I know a number of you Vantage users keep a current copy of their database
as a Test version on the side. Has anyone automated this process to do so
on a daily/weekly basis?

You would need to automate the Shutdown of the database, then restore from a
backup copy, then start the database back up again. It would be nice to
also update the Company name with the current backup date as well.

Any ideas?

Troy Funte
Liberty Electronics



[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

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
4
The problem I have is automatically starting/stopping the database to do the restore. I already have a batch file to restore from the Live backup. There was a thread recently (that never reached conclusion) about starting/stopping the database from a batch file. That is the missing link here.

Troy
----- Original Message -----
From: Winter, Patrick
To: 'vantage@yahoogroups.com'
Sent: Thursday, March 28, 2002 9:14 AM
Subject: RE: [Vantage] Refresh Test Database (Automatically)


You might try automating it by doing a restore from the progress backup of
the live database. I also like to change my FAVORITES BAR background color
to the most annoying color I can as a reminder I'm working in another world.

-----Original Message-----
From: Troy Funte [mailto:tfunte@...]
Sent: Thursday, March 28, 2002 8:00 AM
To: Vantage
Subject: [Vantage] Refresh Test Database (Automatically)


I know a number of you Vantage users keep a current copy of their database
as a Test version on the side. Has anyone automated this process to do so
on a daily/weekly basis?

You would need to automate the Shutdown of the database, then restore from a
backup copy, then start the database back up again. It would be nice to
also update the Company name with the current backup date as well.

Any ideas?

Troy Funte
Liberty Electronics



[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

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/


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/.
(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 the Yahoo! Terms of Service.



[Non-text portions of this message have been removed]
5
Actually, you should be able to do this without starting and stopping.
First schedule the backup command:

\path\progress\bin\probkup online vantage \path\vntgtrn\db\vantback.bu (run
this from vantage directory)

Second schedule the restore some time later:

\path\progress\bin\prorest vantage vantback.bu (run in training directory)

That should do it.

Rick Lane
Intelligent Systems Integration, Inc.
600 Weber Drive
Wadsworth, OH 44281
PH: 330-335-5291
FX: 330-335-7275

"Helping Business Make Intelligent Use of Technology"



-----Original Message-----
From: Troy Funte [mailto:tfunte@...]
Sent: Thursday, March 28, 2002 9:00 AM
To: Vantage
Subject: [Vantage] Refresh Test Database (Automatically)


I know a number of you Vantage users keep a current copy of their database
as a Test version on the side. Has anyone automated this process to do so
on a daily/weekly basis?

You would need to automate the Shutdown of the database, then restore from a
backup copy, then start the database back up again. It would be nice to
also update the Company name with the current backup date as well.

Any ideas?

Troy Funte
Liberty Electronics



[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

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
6
Troy,
I would agree with Patrick, you could set this up using all .bat files. You
could stop and start the services by creating .bat files, and use AT
commands to schedule in NT4.0, but why not use the "online" backup feature?
I can send you samples of .bat files to stop and start services, that I used
when we were on 8.3. The same logic should still apply on 9.1c. I've been
wanting to do the same thing, but it hasn't been high on my list. I might
just bump it up, now that you've got me thinking about it.

Les Tingley
MIS
Decorated Products

> -----Original Message-----
> From: Winter, Patrick [SMTP:pjw@...]
> Sent: Thursday, March 28, 2002 9:15 AM
> To: 'vantage@yahoogroups.com'
> Subject: RE: [Vantage] Refresh Test Database (Automatically)
>
> You might try automating it by doing a restore from the progress backup of
> the live database. I also like to change my FAVORITES BAR background color
> to the most annoying color I can as a reminder I'm working in another
> world.
>
> -----Original Message-----
> From: Troy Funte [mailto:tfunte@...]
> Sent: Thursday, March 28, 2002 8:00 AM
> To: Vantage
> Subject: [Vantage] Refresh Test Database (Automatically)
>
>
> I know a number of you Vantage users keep a current copy of their database
> as a Test version on the side. Has anyone automated this process to do so
> on a daily/weekly basis?
>
> You would need to automate the Shutdown of the database, then restore from
> a
> backup copy, then start the database back up again. It would be nice to
> also update the Company name with the current backup date as well.
>
> Any ideas?
>
> Troy Funte
> Liberty Electronics
>
>
>
> [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
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>
> 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/
>
7
You would have to have the training database stopped to do the restore, and then start it after the restore is complete, wouldn't you? I would like to know how to Stop the training database from the batch file so that the restore process will work.

Troy Funte
Liberty Electronics
----- Original Message -----
From: Rick Lane
To: 'vantage@yahoogroups.com'
Sent: Thursday, March 28, 2002 9:15 AM
Subject: RE: [Vantage] Refresh Test Database (Automatically)


Actually, you should be able to do this without starting and stopping.
First schedule the backup command:

\path\progress\bin\probkup online vantage \path\vntgtrn\db\vantback.bu (run
this from vantage directory)

Second schedule the restore some time later:

\path\progress\bin\prorest vantage vantback.bu (run in training directory)

That should do it.

Rick Lane
Intelligent Systems Integration, Inc.
600 Weber Drive
Wadsworth, OH 44281
PH: 330-335-5291
FX: 330-335-7275

"Helping Business Make Intelligent Use of Technology"



-----Original Message-----
From: Troy Funte [mailto:tfunte@...]
Sent: Thursday, March 28, 2002 9:00 AM
To: Vantage
Subject: [Vantage] Refresh Test Database (Automatically)


I know a number of you Vantage users keep a current copy of their database
as a Test version on the side. Has anyone automated this process to do so
on a daily/weekly basis?

You would need to automate the Shutdown of the database, then restore from a
backup copy, then start the database back up again. It would be nice to
also update the Company name with the current backup date as well.

Any ideas?

Troy Funte
Liberty Electronics



[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

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/


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/.
(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 the Yahoo! Terms of Service.



[Non-text portions of this message have been removed]
8
Les,
I would love to see the batch files to stop/start the test database. That would be a real key here in this process.

One additional step:: is there a way (other than a keystroke macro) to rename the test database company name to something other than our Live database. This would at least flag a stray printout that it's not REAL, and help the user see which database they are on.

Troy

----- Original Message -----
From: Les Tingley
To: vantage@yahoogroups.com
Sent: Thursday, March 28, 2002 9:29 AM
Subject: RE: [Vantage] Refresh Test Database (Automatically)


Troy,
I would agree with Patrick, you could set this up using all .bat files. You
could stop and start the services by creating .bat files, and use AT
commands to schedule in NT4.0, but why not use the "online" backup feature?
I can send you samples of .bat files to stop and start services, that I used
when we were on 8.3. The same logic should still apply on 9.1c. I've been
wanting to do the same thing, but it hasn't been high on my list. I might
just bump it up, now that you've got me thinking about it.

Les Tingley
MIS
Decorated Products

> -----Original Message-----
> From: Winter, Patrick [SMTP:pjw@...]
> Sent: Thursday, March 28, 2002 9:15 AM
> To: 'vantage@yahoogroups.com'
> Subject: RE: [Vantage] Refresh Test Database (Automatically)
>
> You might try automating it by doing a restore from the progress backup of
> the live database. I also like to change my FAVORITES BAR background color
> to the most annoying color I can as a reminder I'm working in another
> world.
>
> -----Original Message-----
> From: Troy Funte [mailto:tfunte@...]
> Sent: Thursday, March 28, 2002 8:00 AM
> To: Vantage
> Subject: [Vantage] Refresh Test Database (Automatically)
>
>
> I know a number of you Vantage users keep a current copy of their database
> as a Test version on the side. Has anyone automated this process to do so
> on a daily/weekly basis?
>
> You would need to automate the Shutdown of the database, then restore from
> a
> backup copy, then start the database back up again. It would be nice to
> also update the Company name with the current backup date as well.
>
> Any ideas?
>
> Troy Funte
> Liberty Electronics
>
>
>
> [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
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>
> 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/
>

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/.
(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 the Yahoo! Terms of Service.



[Non-text portions of this message have been removed]
9
I have an automated batch file to shut down our backup training database and
restore a copy of the backup. Here is the command I use for the shutdown.

<progress path>\proshut <vantage path>\db\vantage -bn

Can someone please post the command to start the database?

Brian

> -----Original Message-----
> You would have to have the training database stopped to do
> the restore, and then start it after the restore is complete,
> wouldn't you? I would like to know how to Stop the training
> database from the batch file so that the restore process will work..
10
Give me a couple of minutes and I'll get them off to you... Les

> -----Original Message-----
> From: Troy Funte [SMTP:tfunte@...]
> Sent: Thursday, March 28, 2002 9:31 AM
> To: vantage@yahoogroups.com
> Subject: Re: [Vantage] Refresh Test Database (Automatically)
>
> Les,
> I would love to see the batch files to stop/start the test database.
> That would be a real key here in this process.
>
> One additional step:: is there a way (other than a keystroke macro) to
> rename the test database company name to something other than our Live
> database. This would at least flag a stray printout that it's not REAL,
> and help the user see which database they are on.
>
> Troy
>
> ----- Original Message -----
> From: Les Tingley
> To: vantage@yahoogroups.com
> Sent: Thursday, March 28, 2002 9:29 AM
> Subject: RE: [Vantage] Refresh Test Database (Automatically)
>
>
> Troy,
> I would agree with Patrick, you could set this up using all .bat files.
> You
> could stop and start the services by creating .bat files, and use AT
> commands to schedule in NT4.0, but why not use the "online" backup
> feature?
> I can send you samples of .bat files to stop and start services, that I
> used
> when we were on 8.3. The same logic should still apply on 9.1c. I've
> been
> wanting to do the same thing, but it hasn't been high on my list. I
> might
> just bump it up, now that you've got me thinking about it.
>
> Les Tingley
> MIS
> Decorated Products
>
> > -----Original Message-----
> > From: Winter, Patrick [SMTP:pjw@...]
> > Sent: Thursday, March 28, 2002 9:15 AM
> > To: 'vantage@yahoogroups.com'
> > Subject: RE: [Vantage] Refresh Test Database (Automatically)
> >
> > You might try automating it by doing a restore from the progress
> backup of
> > the live database. I also like to change my FAVORITES BAR background
> color
> > to the most annoying color I can as a reminder I'm working in another
> > world.
> >
> > -----Original Message-----
> > From: Troy Funte [mailto:tfunte@...]
> > Sent: Thursday, March 28, 2002 8:00 AM
> > To: Vantage
> > Subject: [Vantage] Refresh Test Database (Automatically)
> >
> >
> > I know a number of you Vantage users keep a current copy of their
> database
> > as a Test version on the side. Has anyone automated this process to
> do so
> > on a daily/weekly basis?
> >
> > You would need to automate the Shutdown of the database, then restore
> from
> > a
> > backup copy, then start the database back up again. It would be nice
> to
> > also update the Company name with the current backup date as well.
> >
> > Any ideas?
> >
> > Troy Funte
> > Liberty Electronics
> >
> >
> >
> > [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
> >
> > Your use of Yahoo! Groups is subject to
> http://docs.yahoo.com/info/terms/
> >
> >
> >
> > 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/
> >
>
> 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/.
> (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 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/.
> (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/
>
11
Although it is highly discouraged isn't it possible to write to the database
(via ODBC) using Access? Could a macro be created to connect and overwrite
the Company Name in the Company table? Maybe to set the favorites bar color
too? I don't think there would be too many other "links" to a name field so
corruption risk would be minimal. And you would be trying it in a test
database anyway.
-Todd C.

-----Original Message-----
From: Troy Funte [mailto:tfunte@...]
Sent: Thursday, March 28, 2002 8:31 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Refresh Test Database (Automatically)


Les,
I would love to see the batch files to stop/start the test database.
That would be a real key here in this process.

One additional step:: is there a way (other than a keystroke macro) to
rename the test database company name to something other than our Live
database. This would at least flag a stray printout that it's not REAL, and
help the user see which database they are on.

Troy

----- Original Message -----
From: Les Tingley
To: vantage@yahoogroups.com
Sent: Thursday, March 28, 2002 9:29 AM
Subject: RE: [Vantage] Refresh Test Database (Automatically)


Troy,
I would agree with Patrick, you could set this up using all .bat files.
You
could stop and start the services by creating .bat files, and use AT
commands to schedule in NT4.0, but why not use the "online" backup
feature?
I can send you samples of .bat files to stop and start services, that I
used
when we were on 8.3. The same logic should still apply on 9.1c. I've been
wanting to do the same thing, but it hasn't been high on my list. I might
just bump it up, now that you've got me thinking about it.

Les Tingley
MIS
Decorated Products

> -----Original Message-----
> From: Winter, Patrick [SMTP:pjw@...]
> Sent: Thursday, March 28, 2002 9:15 AM
> To: 'vantage@yahoogroups.com'
> Subject: RE: [Vantage] Refresh Test Database (Automatically)
>
> You might try automating it by doing a restore from the progress backup
of
> the live database. I also like to change my FAVORITES BAR background
color
> to the most annoying color I can as a reminder I'm working in another
> world.
>
> -----Original Message-----
> From: Troy Funte [mailto:tfunte@...]
> Sent: Thursday, March 28, 2002 8:00 AM
> To: Vantage
> Subject: [Vantage] Refresh Test Database (Automatically)
>
>
> I know a number of you Vantage users keep a current copy of their
database
> as a Test version on the side. Has anyone automated this process to do
so
> on a daily/weekly basis?
>
> You would need to automate the Shutdown of the database, then restore
from
> a
> backup copy, then start the database back up again. It would be nice to
> also update the Company name with the current backup date as well.
>
> Any ideas?
>
> Troy Funte
> Liberty Electronics
>
>
>
> [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
http://docs.yahoo.com/info/terms/ <http://docs.yahoo.com/info/terms/>
>
>
>
> 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
http://docs.yahoo.com/info/terms/ <http://docs.yahoo.com/info/terms/>
>

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=219350.1833377.3346791.1269402/D=egroupweb/S=17050071
83:HM/A=935578/R=0/*http://www.gotomypc.com/u/tr/yh/grp/300_1b/g22lp?Target=
mm/g22lp.tmpl>

<http://us.adserver.yahoo.com/l?M=219350.1833377.3346791.1269402/D=egroupmai
l/S=1705007183:HM/A=935578/rand=778083854>

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]
12
Sorry Troy, misunderstood. Use the proserve.bat and proshut.bat commands to
start and stop the database. Search the Progress help file for all the
parameters you can use. Usually the startup parameters are just created in
a .pf file. This can probably just be the normal startup.pf that Vantage
uses.

Rick Lane
Intelligent Systems Integration, Inc.
600 Weber Drive
Wadsworth, OH 44281
PH: 330-335-5291
FX: 330-335-7275

"Helping Business Make Intelligent Use of Technology"


-----Original Message-----
From: Troy Funte [mailto:tfunte@...]
Sent: Thursday, March 28, 2002 9:27 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Refresh Test Database (Automatically)


You would have to have the training database stopped to do the restore, and
then start it after the restore is complete, wouldn't you? I would like to
know how to Stop the training database from the batch file so that the
restore process will work.

Troy Funte
Liberty Electronics
----- Original Message -----
From: Rick Lane
To: 'vantage@yahoogroups.com'
Sent: Thursday, March 28, 2002 9:15 AM
Subject: RE: [Vantage] Refresh Test Database (Automatically)


Actually, you should be able to do this without starting and stopping.
First schedule the backup command:

\path\progress\bin\probkup online vantage \path\vntgtrn\db\vantback.bu
(run
this from vantage directory)

Second schedule the restore some time later:

\path\progress\bin\prorest vantage vantback.bu (run in training directory)

That should do it.

Rick Lane
Intelligent Systems Integration, Inc.
600 Weber Drive
Wadsworth, OH 44281
PH: 330-335-5291
FX: 330-335-7275

"Helping Business Make Intelligent Use of Technology"



-----Original Message-----
From: Troy Funte [mailto:tfunte@...]
Sent: Thursday, March 28, 2002 9:00 AM
To: Vantage
Subject: [Vantage] Refresh Test Database (Automatically)


I know a number of you Vantage users keep a current copy of their database
as a Test version on the side. Has anyone automated this process to do so
on a daily/weekly basis?

You would need to automate the Shutdown of the database, then restore from
a
backup copy, then start the database back up again. It would be nice to
also update the Company name with the current backup date as well.

Any ideas?

Troy Funte
Liberty Electronics



[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

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/


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/.
(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 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/.
(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/
13
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@...
14
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@...
>
>
>
>
> 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/
>

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/.
(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 the Yahoo! Terms of Service.



[Non-text portions of this message have been removed]
15
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/.
(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 the Yahoo! Terms of Service.



[Non-text portions of this message have been removed]
16
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/.
(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 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/.
(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 the Yahoo! Terms of Service.



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

You can manually change the max size of log file. It is under the File
menu in Event Viewer.

Dan

At 11:43 AM 4/5/02 -0500, you wrote:
>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/.
> (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 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/.
> (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 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/.
>(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/
18
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/.
(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 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/.
(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 the Yahoo! Terms of Service.



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