Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I need a little advise, I need to sync a DB that is currently on a Server 2008(SQL Server 2005) machine and I use Studio Express to connect to it. I need a way of syncing this DB to mysql that lives on a NAS on the same network:

Local: DB Engine on server, named, server\sqlexpress and IP = 10.0.0.201

Target: DB on NAS, named, CISCO-NAS and IP = 10.0.0.182

Will need for this to sync every few mins...

I really don't know how to start.

share|improve this question
add comment

3 Answers

One of many ways is to get the mysql odbc installer and install it on you sql2008 server then create an etl job to complete the transfer.

share|improve this answer
add comment

If you can afford, I suggest that you use Oracle Goldengate which targets this sort of things. I used to be an Oracle DB admin a long long time ago and otherwise have no relation to them. Or else you can just export sql, massage the data, and import yourself (you can stream the delta changes to make it look like synching). The effort in that case depends how much your schemas differ and how much nonstandard SQL you are using.

share|improve this answer
add comment

You can try some GUI clients like SQLyog. Where you can import data from SQL Server to MySQL.

share|improve this answer
add comment

Your Answer

 
discard

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

Not the answer you're looking for? Browse other questions tagged or ask your own question.