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?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

wael_tahonCommented:
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
MySQL Server

From novice to tech pro — start learning today.