We’re doing this exact thing at work. We have to take everything from system A and map it to system B. We are writing stored procs to select everything from a table in the old system and insert the data into a temp table with the same schema as the new system. Once the data checks out we migrate it into our live database tables. Can confirm that doing this as bulk operations is much faster than looping through the rows.