Hello,
We are running Vantage 6.1 and recently I was asked to update the vantage practice company every evening after the daily backup.
Here is what I came up with:
<filename: UPDATE-TEST-DBautomatic.cmd>
@echo off
if "%DLC%"=="" set DLC=E:\epicor\Prgs91d
type "%DLC%"\version
:start
SET db=E:\epicor\Train61\db\mfgsys.db
SET backup=E:\epicor\backup\backup.1
CALL :shutdownDB
CALL :updateDB
CALL :end
:shutdownDB
"%DLC%\bin\_mprshut.exe" %db% -by
if errorlevel 0 goto :eof
if errorlevel 1 goto :shutdownError
:updateDB
echo y| "%DLC%\bin\_dbutil.exe" prorest %db% %backup%
if errorlevel 0 goto :eof
if errorlevel 1 goto :updateError
:shutdownError
echo There was an error shutting down the database.
:updateError
echo There was an error updating the database.
:end
echo The update completed successfully.
I am running into trouble now trying to restart the database after the update is complete. According to the Progress help file I should be running the proserve command with a parameter that discribes the servergroup I want to run. If you look in your Progress Explorer Tool you setup these parameters via a submenu in each database and these parameters are stored in your %epicor%\prgs91d\properties\ conmgr.properties file. I noticed that my test database loads two parameter files mfgsystrn61.defaultconfiguration.odbcgroup and mfgsystrn61.defaultconfiguration.mfgsysgroup. When I try to load each of these files separately, or consecutively or together the results are the same; my database seems to be running but this status is not reflected in my Progress Explorer Tool.
Does anyone have any experience doing a similar thing programmatically? If I could get this to restart after the update to the training database was complete I would not have to worry about any human interaction the next morning to have this online for our test group.
Another thought is the ability to update the company names after the database is started as well. We like to name our companies, in the practice database, as the company name prefixed by ***. Any ideas here as well? I think I may have to write some progress code to do this as I do not believe there is a command like utility to make simple update queries into the database.
Thanks for your time.
Michael Kahle
Network Administrator
Steel Craft Corp.
Hartford, WI
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
[Non-text portions of this message have been removed]
We are running Vantage 6.1 and recently I was asked to update the vantage practice company every evening after the daily backup.
Here is what I came up with:
<filename: UPDATE-TEST-DBautomatic.cmd>
@echo off
if "%DLC%"=="" set DLC=E:\epicor\Prgs91d
type "%DLC%"\version
:start
SET db=E:\epicor\Train61\db\mfgsys.db
SET backup=E:\epicor\backup\backup.1
CALL :shutdownDB
CALL :updateDB
CALL :end
:shutdownDB
"%DLC%\bin\_mprshut.exe" %db% -by
if errorlevel 0 goto :eof
if errorlevel 1 goto :shutdownError
:updateDB
echo y| "%DLC%\bin\_dbutil.exe" prorest %db% %backup%
if errorlevel 0 goto :eof
if errorlevel 1 goto :updateError
:shutdownError
echo There was an error shutting down the database.
:updateError
echo There was an error updating the database.
:end
echo The update completed successfully.
I am running into trouble now trying to restart the database after the update is complete. According to the Progress help file I should be running the proserve command with a parameter that discribes the servergroup I want to run. If you look in your Progress Explorer Tool you setup these parameters via a submenu in each database and these parameters are stored in your %epicor%\prgs91d\properties\ conmgr.properties file. I noticed that my test database loads two parameter files mfgsystrn61.defaultconfiguration.odbcgroup and mfgsystrn61.defaultconfiguration.mfgsysgroup. When I try to load each of these files separately, or consecutively or together the results are the same; my database seems to be running but this status is not reflected in my Progress Explorer Tool.
Does anyone have any experience doing a similar thing programmatically? If I could get this to restart after the update to the training database was complete I would not have to worry about any human interaction the next morning to have this online for our test group.
Another thought is the ability to update the company names after the database is started as well. We like to name our companies, in the practice database, as the company name prefixed by ***. Any ideas here as well? I think I may have to write some progress code to do this as I do not believe there is a command like utility to make simple update queries into the database.
Thanks for your time.
Michael Kahle
Network Administrator
Steel Craft Corp.
Hartford, WI
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
[Non-text portions of this message have been removed]