Can tungsten replicator connect to sqlserver through ODBC and standard SQL?

Question

Tungsten appears to support ODBC connections, but it's not clear if a connection to sqlserver would work. Any thoughts?

I want to have sqlserver as the source, and MySQL as the destination. Drop and replace all data might be fine.

If not tungsten, any other tool that can do this?

score 0 · Answer 1 · answered Nov 15 '12 at 11:08

0

Navicat Premium
link: http://www.navicat.com/en/products/navicat_premium/premium_overview.html

I used to copy data from SQL Server to PostgreSQL
It accepts DB: MySQL , PostgreSQL , Oracle , SQLite and SQL Server

answered Nov 15 '12 at 11:08

Zyku

score 0 · Answer 2 · answered Aug 19 '14 at 15:08

I have used linked servers as a way of sharing data between mysql and SqlServer and then have triggers from the sqlServer to the mysql linked server.

if the triggers will not work for you, the other better option will be to setup replication between the sqlserver and the mysql linked server.

2 Answers2