Exporting and Importing Database with Arrays


#1

I am wondering the best approach to export a number of records from a database, process each record which has fields that contain arrays, think of something like Invoice Line Items stored in 1 field, to create an final array with additional fields and then import the created array into a different database.

Im not sure if using json, data dictionaries, data arrays or text will work best.

Any thoughts would be greatly appreciated.