I have a VB.Net project coded with Sql Server for the back -end.
However I just discovered that there is data in a MySql database which I need to retrieve and then insert that data into a table that is sitting in a SQl server table... The data coming from the MySql DB will be multiple rows.. so is it best to grab all the rows at once and then insert in Sql Server or should i insert each row as it goes through the loop. In other words open MySql Db cionnection, grab the row and then insert it into Sql Server. Of course all of this needs to be done with VB.Net code
I have a connection working both into the Sql Server and MySql DB.
Any help or insight would be much appreciated