database backup 
Author Message
 database backup

I've developed a database application w/ PDox7 (Win95) and am trying to
develop a backup feature. I want to be able to create an compressed
archive containing all of the tables and associated files from 3
different directories (oops, I'm supposed to call them folders now).
Although I have no allegance to any particular format, PKZip
compatability would be nice. I also require long filename support.

I've done some searching, but the Win95 compliant apps don't seem to
support command line switches (I'd prefer that the compression and
archiving occured in the background), and I'd rather not have to spend
hundreds of dollars on a commercial compression DLL.

Any suggestions????

--
                           Gregory S. Lyons
                         ---------------------



Sun, 17 Oct 1999 03:00:00 GMT
 database backup

Quote:
> I've developed a database application w/ PDox7 (Win95) and am trying to
> develop a backup feature. . . .  and I'd rather not have to spend
> hundreds of dollars on a commercial compression DLL.

Spend the money. They wouldn't be able to sell copy #1 if there wasn't a
reason. Yes there are cheap alternatives. But cheap may refer the
quality rather than the cost.

Daniel A. Morgan



Sun, 17 Oct 1999 03:00:00 GMT
 database backup

I use DynaZip.  It costs lot up front ($300) but its worth it.
It's easy to use, has sample PDox code and you can
redistribute it royalty free.  Sell your app and make up the difference.
I was in the same situation.  I tried using PKZip but it drop to the
dos prompt and confuses the user.  Also, Dynazip will let you format the
disk and spann disks with no problem.  By the way DynaZip is PKZip
compatitble.



Quote:
> I've developed a database application w/ PDox7 (Win95) and am trying to
> develop a backup feature. I want to be able to create an compressed
> archive containing all of the tables and associated files from 3
> different directories (oops, I'm supposed to call them folders now).
> Although I have no allegance to any particular format, PKZip
> compatability would be nice. I also require long filename support.

> I've done some searching, but the Win95 compliant apps don't seem to
> support command line switches (I'd prefer that the compression and
> archiving occured in the background), and I'd rather not have to spend
> hundreds of dollars on a commercial compression DLL.

> Any suggestions????

> --
>                            Gregory S. Lyons
>                          ---------------------




Mon, 18 Oct 1999 03:00:00 GMT
 database backup

Quote:

> I've developed a database application w/ PDox7 (Win95) and am trying to
> develop a backup feature. I want to be able to create an compressed
> archive containing all of the tables and associated files from 3
> different directories (oops, I'm supposed to call them folders now).
> Although I have no allegance to any particular format, PKZip
> compatability would be nice. I also require long filename support.

> I've done some searching, but the Win95 compliant apps don't seem to
> support command line switches (I'd prefer that the compression and
> archiving occured in the background), and I'd rather not have to spend
> hundreds of dollars on a commercial compression DLL.

I'm afraid it does cost "hundreds of dollars", but I have had excellent
service from DynaZip from Inner Media.  And the tech support we received
was off the scale.  I don't have their web address here at home, but it
shouldn't be hard to find.

Al Solter
Primex Technologies
Red Lion, PA



Mon, 18 Oct 1999 03:00:00 GMT
 database backup


says...

Quote:

>On Wed, 30 Apr 1997 13:08:56 -0400, "Gregory S. Lyons"

>>I've developed a database application w/ PDox7 (Win95) and am trying to
>>develop a backup feature. I want to be able to create an compressed
>>archive containing all of the tables and associated files from 3
>>different directories (oops, I'm supposed to call them folders now).
>>Although I have no allegance to any particular format, PKZip
>>compatability would be nice. I also require long filename support.

>>I've done some searching, but the Win95 compliant apps don't seem to
>>support command line switches (I'd prefer that the compression and
>>archiving occured in the background), and I'd rather not have to spend
>>hundreds of dollars on a commercial compression DLL.

For compression I use Xtree Gold (eg to move/copy databases by floppy or
internet). It's wonderful. Tag the directories, press Ctrl-F5, give it a
filename with an exe extension, and it creates a self-extracting file within
minutes. Or you get it to 'span disks', just like a backup programme.
Databases have lots of redundant space, so compression ratios are usually
very impressive. Only problem, the DOS version I use (and it's I think the
only DOS programme I still use regularly on Win95) can't handle long
filenames, you end up with that tilde character ~ in the filename. But who
cares.

For backups you can get one of those marvellous JAZ drives with 1 gb capacity
and hard disk class access speed. If you also use 1 gb partitions on your
working drive, you have a perfectly matched backup system. Copying new and
changed files at the end of the day usually takes me no longer than a few
minutes. And if your BIOS supports it, you can boot directly of the JAZ drive
if your hard disk fails. Unless your databases are enormous you won't need
compression, and Iomega has all sorts of backup and archiving programmes for
its drives.

Although in PX you can just use the execute procedure to run a backup
programme for example, you may have to close down any open files (tables,
forms etc). I've had the occasional sharing violation with some programmes
even if both were only reading. Why bother with backing up from within
Paradox anyway?

Kiran

PS: Remember, backups are a nuisance, so keep them as simple as necessary.



Sat, 06 Nov 1999 03:00:00 GMT
 database backup

Just a note to remind anyone backing up Pdox to backup *ALL* files
associated with the tables.  Do not rely on copying just the DB file; you
will end up with corrupted tables.



Mon, 08 Nov 1999 03:00:00 GMT
 
 [ 6 post ] 

 Relevant Pages 

1. Database backup / database File Backup

2. Restore life database backup to testing database

3. I need recommenddation on good SQL database backup

4. Cluster Database Backups Question

5. Database Backup Failure

6. Database Backup and DTS?

7. Problem with Transaction and Database backup

8. database backups

9. database backup error

10. Database backup Question

11. SQL Server database backup

12. SQL Server Database Backup Errors


 
Powered by phpBB® Forum Software