Try the compression route but with SQL Anywhere. You can tell SQL Anywhere
to shrink a database for distribution using the DBSHRINK utility that comes
with it. When the database is run by the engine, a write file and log may
be maintained on a RW device but the original data is not written to or
uncompressed.
--
Chris Baker
Technical Specialist, Sybase Enterprise Products
Visual Systems Development Group
Phone: (416) 368-5464x245
Fax: (416) 368-2767
http://www.visual.com
David <kiko1_at_worldnet.att.net> wrote in article
<5uolb0$hij_at_bgtnsc03.worldnet.att.net>...
> Drew,
>
> I'm not sure if you've tried it yet ... but a couple of options...both
deal
> with compression.
>
> Create an install of your DB using 'whatever' ....it should have an
option
> for a single flat file ... even install builder does....
>
> Or just zip it....
>
> I had a 128MB DB ... actually, an ORACLE .dmp file .... and zipped it
down
> to about 20MB. .. given a compression ratio of about 6X .... then a
~3.9GB
> DB should be able to be compressed down to fit on 1 CD(650MB)
>
> ....and I'm no expert on them ... but I've read that DVDs can handle
> 4.6GB...although $$$$
>
> ..and worse case, you can use a tape backup .... I know there are tape
> drives out there that can handle 6-8GB using compression
>
> drew <drew_at_cyberway.com.sg> wrote in article
> <34109447.930FF22C_at_cyberway.com.sg>...
> > Hi,
> >
> > I'm trying to create a series of 6 CDs containing a database of names
> > and addresses.... the amount of data is quite huge -- about 3-4 gig --
> > and it consists of many tables with links to be accessed using
> > Powerbuilder....
> >
> > Has anyone out there created something like this before? Which
> > databases should I use that can support spanning? Or should I consider
> > another storage media instead of using CDs?
> >
> > Thanks,
> > Drew
> >
> >
> >
> >
>
Received on Mon Sep 08 1997 - 00:00:00 CDT
