Can I use federated tables to make the integration of mysql and mssql ? I tried and it worked mysql to mysql , but if I try to connect to mssql , do not work.
Thank You.
Asked
Active
Viewed 3,002 times
1 Answers
1
As per MySQL 5.7 Reference Manual - 15.8.1 FEDERATED Storage Engine Overview:
The local server communicates with the remote server using MySQL client C API functions.
... which, naturally, can only connect to mysqld.
MySQL Workbench - Database Migration: Microsoft SQL Server to MySQL gives an overview of options to transfer data between mssql and mysql. They can be summarized as:
- Access
mysqlfrommssqlthrough ODBC by adding the former as a "linked server" - Transfer data between the two (either direction) with IDEs (by hand, i.e. one-time)
- Transfer data between the two (either direction) with a program that can access both, possibly including data conversion
ivan_pozdeev
- 33,874
- 19
- 107
- 152
-
Thanks for the answer, but you some way to do this integration? – Matheus Campos Dec 22 '14 at 19:46