Hi,
Yes Archival is very much important for the Data maintenance.
1)What strategy would you suggest for data archiving?
Here to defining the strategy for archival is depends on how your organisation is going to
use the archived data ,For example if it is for Data analysis and normal SSRS reporting purpose then you need may
define strategy like just archiving all the data in the plain SQL Database[Keep it in Azure] with the same CRM table structure.
To achieve this kind of approach you can use SSIS packages to run your jobs and archive it.
- Suppose if you want to create an another organisation like Archived Data Organisation then you need to
Archive like a another MSCRM oRganisation Database so that Users can access the archived application for any purpose. To
achieve this you can existing tools are Kingsway soft or SCRIBE tool etc.,
you can refer so many articles are available to know about SCRIBE onpremise and SCRIBE online as well.
-When you start doing the archival you should perform the ONGOING ARCHIVAL as well for the data maintenance.
2)Would the deactivation of records be a good option for this?
Here deactivation is not a good option,because again the data is going to lie in the same place which will
not give you any performance betterment of teh system.For deactivation need an effort.
3)When you are archiving you need to delete the archived records and then only your system will become a slimdown system.You can try using the SCRIBE toold even for deletion of records from your system.
Always try to do a POC [proof of concept] with minimum 3 options for deletion and note down the timings of each POC execution and then implement the
complete solution.
Else just contact microsoft for the same requirement and check with them is there any tool is available ready made with them for deletion.
Hope this helps.
Regards,
Thangamani
