How would you move 10,000 files in this case?

Maybe this is an off-the-wall request, but here’s my situation:

I have a client that wants to transfer ~10,000 PDFs of “File” records that are loaded into his Knack app (each on a separate record) into a custom field in Wordpress on his website. The field would be created by Advanced Custom Fields.

The thing is, those records in Knack have other data (“Date Filed” and so forth) that also need to be transferred along with those PDFs.

Anyone have any ideas as to how I would mass-transfer those records? Or maybe a best/worst-case scenario of how to do it?

Thank you for any help you can give.

Hello Jonathan,

This can be done using creating a small programme which can read all knack data and post whatever you need (MySQL or MS SQL or your wordpress database )

I have moved data many time into MSSQL and files into personal server

Regards,
Sunny Singla
ssingla1985@gmail.com
+919855089359