Transfer data from mysql server table to a remote MS SQLServer 2005 table

Dear Experts:

I am in need of advice on how to best transfer data from MySQL server to a MS SQL server 2005. This servers are in different cities. I have to take some information from a database and update it to another, perhaps keep a table update. The two database servers are different platforms one is Linux MySQL server to  MS SQL server 2005.  I am using a VPN tunnel  to have connectivity with the two sites. If you could give me an idea that can help me with this scenario, I would appreciate it. I do not want to copy the whole source table just the daily changes that take place to it. Thanks, M
marceloNYCMiddle-Tier AdministratorAsked:
Who is Participating?
 
wael_tahonConnect With a Mentor Commented:
The MySQL server can be registered as a linked server inside the SQL Server then you can build a job that runs on a specific time periodically or as you want and this job runs a SQL script that do the table update.

Linked Servers:
http://msdn2.microsoft.com/en-us/library/ms188279.aspx

Jobs:
http://www.databasedesign-resource.com/sql-server-jobs.html
http://msdn2.microsoft.com/en-us/library/ms187910.aspx
0
 
marceloNYCMiddle-Tier AdministratorAuthor Commented:
Thanks this was very helpful!!!! Sorry it took me so long to accept  the question. Cheers, M
0
 
marceloNYCMiddle-Tier AdministratorAuthor Commented:
Thanks!
0
All Courses

From novice to tech pro — start learning today.