Archiving table data
We have reached the 500mb limit with one of our tables. Is there process for archiving older data into another table so that it will still be seen in the reports we created? I looked into saving in ...
Forum Discussion
Thanks for the reply.
The archive table will need to be accessed via the same report that is showing the original table.
For example if we are storing "employees" and "hired date" in a table called "personnel". The table "personnel" has reached the 500mb limit. The report "Date Hired" list employees hired during a date range. We want to be able to archive off all employees hired in the years 2016 and 2017. If we copy the table "personnel" to "personnelArchive" then delete all employees after 2017, we will have the correct data archived. We then delete all employees in the "personnel" table hired before 2018. At this point, how do we create a report that will allow us to search "Date Hired" and still capture the archive data as well as the new data? If the employee is hired before 2018 look in the "personeelArchive" table and if the employee is hired after 2018 look in the "personnel" table.
The archive table will need to be accessed via the same report that is showing the original table.
For example if we are storing "employees" and "hired date" in a table called "personnel". The table "personnel" has reached the 500mb limit. The report "Date Hired" list employees hired during a date range. We want to be able to archive off all employees hired in the years 2016 and 2017. If we copy the table "personnel" to "personnelArchive" then delete all employees after 2017, we will have the correct data archived. We then delete all employees in the "personnel" table hired before 2018. At this point, how do we create a report that will allow us to search "Date Hired" and still capture the archive data as well as the new data? If the employee is hired before 2018 look in the "personeelArchive" table and if the employee is hired after 2018 look in the "personnel" table.
