Results 1 to 5 of 5
  1. #1
    Join Date
    Dec 2002
    Posts
    123

    Unanswered: Best way to archive data?

    Hi,

    What is the best way to archive 8-9 years worth of data...we have a customer that would like their old data removed from the production database and handed over to them in some format.. what's the best way to go about this? Thank you!

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    I would start with describing the "some format" thing.
    ---
    "It does not work" is not a valid problem statement.

  3. #3
    Join Date
    Dec 2002
    Posts
    123
    Well, we want to let them know what options they have... CD, csv files, etc...I prefer to do it the easiest way... and wanted to know how people generally off-load data....what's the most common format?

  4. #4
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    I think the most common format is the one that is suitable for the purpose. What your customer are planning to do with the data? Do they want to be able to analyze it and run some reports? Do they want to be able to re-create the database? Do they need an ability to load it into another DBMS? ASCII files (CSV or not) are the lowest common denominator, but they must be accompanied by extensive documentation describing their format, otherwise in 6 months you will struggle to find anyone who has a clue about what's in there. XML is more verbose but is somewhat self-documenting. On the other hand, you might just as well give them a compressed DB2 backup image...
    ---
    "It does not work" is not a valid problem statement.

  5. #5
    Join Date
    Dec 2002
    Posts
    123
    Thank you..I will ask our customer.. I know that they may want to analyze it and run some reports on it in the future. If they ask for the data in CSV format, how can that be done? Their data is not in a separate database.. it's mixed with data of our other clients as well.. for example, we have one tablespace for readings called Reading_tblsp. Is there some utility I can use to do the archive of their data for us? And after we have their data offloaded in a certain format..we want to remove all this data from our original database. This is data for 10 years.. millions of records.. so don't think a simply query will cut it.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •