dbTalk Databases Forums  

dbShrink and dbExpend

sybase.public.sqlanywhere.general sybase.public.sqlanywhere.general


Discuss dbShrink and dbExpend in the sybase.public.sqlanywhere.general forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Sudarat
 
Posts: n/a

Default dbShrink and dbExpend - 08-21-2009 , 11:21 AM






Hello,

We have been using dbShrink and dbExpand to
compress/decompress the database. After we upgrade from
9.0.2 to 11.0.1, these two commands are not available any
more.

Do you have any other commands in Sybase SQL anywhere
V11.0.1 in order to compress/decompress database?

Any suggestions are appreciated.

Thanks,
Sudarat.

Reply With Quote
  #2  
Old   
Nick Elson [Sybase iAnywhere]
 
Posts: n/a

Default Re: dbShrink and dbExpend - 08-21-2009 , 11:38 AM






Other than winzip/winrar?

As you know we no longer support compressed databases.
We also no longer support write (.WRT) files so running
with full database compressed files is not an option either.

Compressing LOB data is always an application option
though ... You can do that with a client-side library/function
of your choice ... You can also do that on the server using
the COMPRESS/DECOMPRESS functions ...

Hopefully something there is helpful.


<Sudarat> wrote

Quote:
Hello,

We have been using dbShrink and dbExpand to
compress/decompress the database. After we upgrade from
9.0.2 to 11.0.1, these two commands are not available any
more.

Do you have any other commands in Sybase SQL anywhere
V11.0.1 in order to compress/decompress database?

Any suggestions are appreciated.

Thanks,
Sudarat.

Reply With Quote
  #3  
Old   
Nick Elson [Sybase iAnywhere]
 
Posts: n/a

Default Re: dbShrink and dbExpend - 08-21-2009 , 11:42 AM



some links that may be helpful

http://dcx.sybase.com//1101en/dbusag...s-5092374.html
http://dcx.sybase.com/1101en/dbrefer...395665734.html
http://dcx.sybase.com/1101en/dbrefer...s-3798472.html


<Sudarat> wrote

Quote:
Hello,

We have been using dbShrink and dbExpand to
compress/decompress the database. After we upgrade from
9.0.2 to 11.0.1, these two commands are not available any
more.

Do you have any other commands in Sybase SQL anywhere
V11.0.1 in order to compress/decompress database?

Any suggestions are appreciated.

Thanks,
Sudarat.

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.