Board index » cppbuilder » Data archiving

Data archiving


2004-09-10 11:06:24 PM
cppbuilder40
I have to archive data from SQL server.
My idea is that I use ADO and simply save data and later load that data
using some methods of ADO components.
Does anybody maybe have some better idea?
Since I will have several files I want to aggregate this files in one, can
anybody suggest the best method?
Thank you.
 
 

Re:Data archiving

"Johny" < XXXX@XXXXX.COM >wrote:
Quote

[...] Since I will have several files I want to aggregate
this files in one, can anybody suggest the best method?
This is not a trivial task. I suggest that you simply archive
the database instead but if you insist on proceeding ...
You'll need some sort of header(s) that preceed the actual data
so that you'll know what you're dealing with if you need to
restore the data at any point. For example, you'll need to
distinguish between customer records and invoice records.
You'll also need some way to know when you've reached the end
of one table and started on another.
Don't use AnsiStrings, use char[] instead and you'll also want
to include some sort of compression as well:
sources.redhat.com/bzip2/
www.gzip.org/zlib/
~ JD