Wesley,

Several good methods have been pointed out.

If you happen to have ORBiT's BACKUP/3000 (BACKUP+/iX) on your boxes, there's another way, maybe a
little more secure.

We do a:  >STORE <rootfile.group.account>;<diskfilename>;DBSTORE;SHOW;COMPRESS=3 etc...

This produces always two PRIV-diskfiles which are very well compressed, I believe.

Now it's easy to :DSCOPY these two single files to the other unit and then do a BACKUP+/iX restore
like:

>RESTORE <diskfilename>;<rootfile.GROUP.ACCOUNT>;DBRESTORE;SHOW etc...

Using this method, you will either have the whole based stored/restored in good condition or no
files at all, due to the ;DBSTORE and ;DBRESTORE options. Furthermore BACKUP/3000 won't do the trick
if you misspell something etc. - that's another benefit.


This works fine for us, even over a satellite-link...


With kind regards,

/Hans

====================================================================
Hans-Ole Kaae                       Vox: (+45) 87 34 55 07
IT-Consultant                       Fax: (+45) 87 34 55 66
ScanConsult·IT-Partners ApS         Mob: (+45) 40 42 55 07
Udviklingsparken Aarhus             E-mail: [log in to unmask]
Soenderhoej 14
DK-8260  Viby J.
Denmark                             Web: http://www.scanconsult.dk


> -----Original Message-----
> From: HP-3000 Systems Discussion [mailto:[log in to unmask]]On
> Behalf Of Wesley Setree
> Sent: Tuesday, May 18, 1999 8:12 PM
> To: [log in to unmask]
> Subject: DATABASE TRANSFER
>
>
> We have a 967 (production) and a 927 (test) and we want to update the test
> database with the production database on a regular schedule (probably
> weekly). I used dscopy but I have to use different file codes for
> different
> files (root, detail, misc.) and I started putting them in a job stream but
> that seems like it will be a lot of code. Can I transfer the files any
> other way, like FTP, instead of a STORE/RESTORE procedure? We do
> not have a
> Unix box and our network is limited to a few PC's in the MIS dept.  Any
> ideas would be appreciated.
>
> Wes "sorry I complained about the volume of mail" Setree
> System Analyst/Administrator
> Calsonic-Yorozu Corp.
>