vfp 3.0

i am copying information from fields from one database
to another database and field names are different.

what is the best way to accomplish this? copy fields
to arrays and then use replace command?

do i need to open both databases at the same time to
do this?

Thanks and have a good day.

Becky