I have two databases (Source and Target). I am trying to export records from the Source database into the Target database. I start by using the 'Export Records' script step in the Source db, and temporarily place records in a temp path. Then I open up the Target db, using the same script, and choose the file that I saved under the temp path.
My questions are:
1. What is the best format for me to export the records from the source: Tab or xlsx?
2. When Importing, if I exported the file as a Tab delimited, the field names are not exported, so when I import, I cannot use the 'matching field names' category.
Any suggestion on a similar process?