Link to home
Start Free TrialLog in
Avatar of amerretz
amerretzFlag for Australia

asked on

Start and Stop Workgroup engine via commands

Hi,

I am using Pervasive SQL workgroup V8. I woul dlike to know how I can Start and Stop Workgroup engine via commands so that I can put these in a batch file.

Does anyone know these commands?

Thanks
Avatar of Mirtheil
Mirtheil
Flag of United States of America image

To start:
w3dbsmgr.exe -srde
To stop:
pvkillwg.exe

Both of these are in the PVSW\BIN directory.
Avatar of amerretz

ASKER

I dont have a pvkillwg.exe in my bin folder.

Also how would I put this in a script?

Thanks
What's the exact version of PSQL you're using?  I'll check my V8 machine later but I believe it is installed with PSQL V8.5 and later.  

How you put it into a script is really up to you.  What knd of script are you talking about?  What are you trying to do with the script?
I am using Pervasive Workgroup Version 8.6. The file you mentioned above is not in my BIN directory.

I would like to create a scipt that will shutdown the workgroup engine at a specific time for backup purposes then restart the engine after the backup is finished.

Thanks
ASKER CERTIFIED SOLUTION
Avatar of Mirtheil
Mirtheil
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
I am trying to backup data which uses PSQL. The data is used by an accounting application. This application has a company data directory which contains a heap of *.dat files and some *.ddf files.

When reading the pervasive help guides on continuous opteration it gives examples on how to backup using the butil -startbu command. The file that it gives in the example is a *.mkd file. I cannot seem to find any reference in the accounting data which contains a *.mkd file.

How would my application be using pervasive in this case? Should I have a *mkd file somwhere?
The MKD extension is the default.  Each application may be different.  I've seen *.DB, *.DAT, and even no extension.  If you've got *.DAT and *.DDF, those are the data files.