maryam_adnan
asked on
Copy sql server table to remote mysql
Hello,
Please, I need to copy Sql server table ( around 50,000 record) to a remote mysql table, the linked server method is too slow, is there any other way ?
I tried this application (dbconvert , dbsync , linked server) but it is the same speed.
Regards
Please, I need to copy Sql server table ( around 50,000 record) to a remote mysql table, the linked server method is too slow, is there any other way ?
I tried this application (dbconvert , dbsync , linked server) but it is the same speed.
Regards
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Hi,
Thank you for your reply.
Please I want to do this automatically because I have to update database regularly
Kind Regards
Thank you for your reply.
Please I want to do this automatically because I have to update database regularly
Kind Regards
Using the Export wizard , you can creates a SSIS small package that auto-runs
What resources do you have?
I.e use bcp/powershell to query and create a CSV/tsv. FTP/scp the data to the remote server where you can hav a script monitoring uploaded files and running MySQL load data from file directive.
You should use something like md5sum that you will use on the remote side to verify the received data is complete as it was sent.
I.e use bcp/powershell to query and create a CSV/tsv. FTP/scp the data to the remote server where you can hav a script monitoring uploaded files and running MySQL load data from file directive.
You should use something like md5sum that you will use on the remote side to verify the received data is complete as it was sent.
Missed that you are going ms sql to MySQL.