Take the 2-minute tour ×
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.

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

migrated from stackoverflow.com Apr 16 '13 at 13:28

This question came from our site for professional and enthusiast programmers.

    
1. You want permanently transfer data from MsSQL to MySQL 2. or you want enable data synchronization between these dbs? –  Shahriyar Rzayev Apr 16 '13 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 '13 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 '13 at 9:44
    
What version of SQL Server are you using? Is the Data Transformation DTS or SSIS? How often will you be transferring this data? (As the first comment asked, is it once or recurring?) And what latency is acceptable if it is recurring? –  Thronk Oct 8 '13 at 17:22
    
I am updating products on a database on a daily basis. using sql 2003 and dts packages. I was connecting the 2 databases and copying the data but was so slow. in the end I exported the data to a csv file then uploaded via ftp then ran a php script on the remote db to import the data, was more to learn but runs so much faster now. –  John Spencer Oct 10 '13 at 10:19
add comment

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.