XML and ODBC
-
I am trying to figure out what is the best way to store old records in a database. Basically, I am trying to write some kind of archive function that will do record maintenance to keep the database relativly small. So if I have a table of purchases and I want to keep only the records that are newer than 90 days and move the older ones to some archive file. My question is, what is the best way to store the archived records? XML? another database? some other method? I am leaning toward XML but I really don't know enough about it. So on to my next question. Does anyone have a class that will take a recordset using ODBC and write an XML file? Thanks in advance. *********************** Tony Fontenot Recreational Solutions tony@recsolutions.com ***********************
-
I am trying to figure out what is the best way to store old records in a database. Basically, I am trying to write some kind of archive function that will do record maintenance to keep the database relativly small. So if I have a table of purchases and I want to keep only the records that are newer than 90 days and move the older ones to some archive file. My question is, what is the best way to store the archived records? XML? another database? some other method? I am leaning toward XML but I really don't know enough about it. So on to my next question. Does anyone have a class that will take a recordset using ODBC and write an XML file? Thanks in advance. *********************** Tony Fontenot Recreational Solutions tony@recsolutions.com ***********************
Personally, I would just go with another database. A database is obviously more robust than XML. Transactions, automatic backups, etc. XML is just a plain text file. Backups and transactions would have to be handled manually.