I guess the only way around it is to use temp tables. 1 for SQL and 1 for MySQL. Since I can move all the data in one dirrection. I will send the data to a temp table that will use a trigger to update the local table.