I have an app with a requirement to hit an external mssql db and move
the data to a local mysql database. What's the best way to do this?
I was thinking of querying the mssql db and writing the contents to a
flat file then using mysql load data from infile query to pump it in
but I am not sure if this is the best option so am looking for
suggestions....