I currently copy data between my local SQL Server to a remote MySQL database linking in SQL and doing a data transformation task but now I'm sending lots of data it is getting very slow.
Just after some advice please on which way anyone would recommend I should go about getting large chunks of data from one to the other. I know there are various ways of doing this, I am just unsure if I should:
- Keep my link via SQL.
- Export the data to a CSV file then run a script on the remote end.
- Something else?
Just need a pointer in the right direction.