My company have multiple site collections that are all getting quite large and we will reach our overall storage limit within 6 months. Currently we have only a manual solution for moving data off the sites in to external HDD which is very time consuming.
I would like to automate this process by using metadata associated to the content types (currently using 3 content types) to activate a workflow to copy data to an archive site collection then delete the data from the source. This will allow me to then use ShareGate to copy the data from SP to the HDD.
I need to maintain all metadata as well as all versions as this is a company requirement. Currently we have have 8 Site collections with separate DB that I wish to use this workflow on, with all data going to the one Archive Site collection again on a separate DB.
I have tried quite a few different SPD workflows but as I was researching more and more found that OOTB is unable to migrate the metadata and maintaining the version history.
What I'm seeking is a code or some advise on how to achieve this automation.