Unanswered: Data Archival strategies and suggestions
We have a requirement for archival of data on a regular basis.
We have a set of tables and its related tables that needs to be archived so that we would be able to bring the archived tables on line with minimal data movement. I am thinking of something like the Table partioning in Oracle database server where you can partition a table in several tablespaces EG Q1,q2,q3,q4 for the four quarters. You can selectively take the tablespace online and offline at the drop of a hat with a couple of commands in oracle. Do we have something similar to that? We are using the workgroup server edition.
Any suggestions and/or white paper articles on this topic are very appreciated.