Discussion:
How ASE15.0.2/ASE15.0.3 database dump files to be "mined" for a single table.
(too old to reply)
hitgon
2009-12-24 07:24:03 UTC
Permalink
Raw Message
Hi,
Good days

I'm using Sybase ASE 15.0.2. / ASE 15.0.3

How can we load single table from database dump file.
In documentaion I've read that
A new ASE 12.5 feature allows database dump files to be "mined" for a
single table.
Thus an entire database loaded is not required when only a single
table restore is needed.
Rob V [ Sybase ]
2009-12-24 08:04:23 UTC
Permalink
Raw Message
The feature is called 'archive database'. It allows you to access a DB dump
file directly, i.e. without really loading it first (you must still run
'load database', but it will be very fast irrespective of the size of the
dump).
See http://www.sybase.com/files/Product_Overviews/ASE1502_newfeatures.pdf
for details.

HTH,

Rob V.
-----------------------------------------------------------------
Rob Verschoor

Certified Sybase Professional DBA for ASE 15.0/12.5/12.0/11.5/11.0
and Replication Server 15.0.1/12.5 // TeamSybase

Author of Sybase books (order online at www.sypron.nl/shop):
"Tips, Tricks & Recipes for Sybase ASE" (ASE 15 edition)
"The Complete Sybase ASE Quick Reference Guide"
"The Complete Sybase Replication Server Quick Reference Guide"

mailto:***@YOUR.SPAM.sypron.nl.NOT.FOR.ME
http://www.sypron.nl
Sypron B.V., Amersfoort, The Netherlands
Chamber of Commerce 27138666
-----------------------------------------------------------------
Post by hitgon
Hi,
Good days
I'm using Sybase ASE 15.0.2. / ASE 15.0.3
How can we load single table from database dump file.
In documentaion I've read that
A new ASE 12.5 feature allows database dump files to be "mined" for a
single table.
Thus an entire database loaded is not required when only a single
table restore is needed.
Loading...