>Does DynaZip skip open files? Someone said so a few years back so I never looked at it again.
>
I don't know, since I haven't used it for that, and don't think that the Zip mechanism is an adequate tool for backup. But that's my opinion. what I've done with Zip files is used them as a means of receiving and distributing compressed data that is not used as a part of the shared database environment.
>WINZip protects me in this critical area. So I just paid for it and its done. What do you do for backups in 24x7 environments? Kick everyone off?
>
No, I use CA-ArcServe, which does a fine job of backing up open files. And I force people out of systems, and knock loose locks during backup, so that I have a reliable, known state for my backup.
And if I have a real mission-critical environment, I use SQL Server or CA-Ingres as a backend, which provide journalling and transaction processing facilities as a part of their environment, not to mention things like scalability and fault tolerance capabilities.
use the right tool for the right job...
>__Stephen Russell
>Memphis Visual FoxPro Users Group
>
>>>Is there a way to zip and unzip tables from within Foxpro or Fox exes? I found nothing under the help index.
>>>
>>
>>I've used PKUNZIP, building command lines from VFP and launching it with CreateProcess(), and have recently started playing with DynaZip, which is a third party utility that seems to work well.
>>
>>The Zip format is not native to DOS/Windows, so you won't find anything in the MS-supplied documentation on them.
>>
>>>Windows has its own compression tool. We ought to be able to call it from VFP, but how?
>>>
>>
>>The decompression utility is available for redistribution (in fact, it's present in bith Win9x and NT 4), but you cannot legally redistribute the compression utility. The functionality to extract compressed files is also available through the Win32 SETUP API. You can call the DOS command line utility EXTRACT the same way you'd call PKUNZIP, via RUN or CreateProcess(); EXTRACT /? will list the command line parameters available for it.
>>
>>>The goal is to enable a client to operate upon compressed data without manually decompressing/recompressing. Any ideas?
>>
>>If you really need to compress data for other than data, you might consider putting the data on an NTFS volume and enabling NTFS compression tranmission purposes (IOW, store the data on a routine basis compressed by the NT operating system; I do not recommend using Novell's compression because of problems I've seen with some Novell Client software and compressed volumes). I've never been an advocate of any of the DriveSpace family of tools for Win9x, but they also can do on the fly compression and decompression without any special programming.
