Tell me more ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.
up vote 0 down vote favorite

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.

share|improve this question
1. You want permanently transfer data from MsSQL to MySQL 2. or you want enable data synchronization between these dbs? – Shahriyar Rzayev Apr 16 at 13:53
What is "linking in SQL"...? Federation? Using mysqldump piped to the mysql client? Please describe how you're doing it now, in a bit more detail, as there are some optimizations you may not be doing. – Michael - sqlbot Apr 17 at 6:02
I currently in my MSSQL server have my MYSQL database as an ODBC Data source, I then do a data transformation task between the local and remote tables im updating. Works but is slow. – John Spencer Apr 18 at 9:44

migrated from stackoverflow.com Apr 16 at 13:28

Know someone who can answer? Share a link to this question via email, Google+, Twitter, or Facebook.

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.