What will be the best practice to fetch data from MSSQL and insert/update to MySQL?

QuestionsWhat will be the best practice to fetch data from MSSQL and insert/update to MySQL?
sethbeckerman5 Staff asked 4 years ago

So, i'd like to fetch data from MSSQL and insert/update in MySQL.
I have this script:

Should i create an array and insert whole the array in MySQL, is that possible?
Or should i iterate the fetched array and insert it into MySQL row by row?
I have this in mind:

What will be the best way?


View on Stack Overflow