Transfer of Data

John needs to transfer a data set of 50,000 tuples from database schema1 to database schema2. Database schema1 contains table1, which has seven attributes and database schema2 contains table2, which has five attributes. How will he perform the transfer of the data set of 50,000 tuples from database schema1 to database schema2 at the database level? Which fields will be kept, lost, or combined?

Please provide example SQL diagrams and show all design work to support your response. Among all techniques available which one is the most efficient? Why?