Hi, we are in the process of having our website re-developed and as part of the integration they will require a copy of our SQL database. This is to ensure that all of the functionality works correctly and that there will be no issues when the website is linked to our production database at launch.
We trust the web agency implicitly, they have signed a Non-disclosure agreement and we know they will not use any of the data in our database to their advantage but as a safeguard - our Directors have asked me to remove any data that has been added in the last 12-24 months.
The majority of this data consists of candidate CVs and client records - is it possible to delete all data from a number of different tables that is older than 18 months for example?
I am more than happy to release a copy of the data for the purposes of the website re-development, but ideally I would like to satisfy our Directors wishes and protect ourselves.
I look forward to hearing your thoughts and comments.
Thanks in advance!