This forum has migrated to Microsoft Q&A. Visit Microsoft Q&A to post new questions.

Remove From My Forums

Query MySQL DB

Question
0

Sign in to vote

How do I query a MySQL DB from Azure MS SQL Database. In my Old environment (SQL 2008) I do it via Linked server, but Linked servers not available in Azure SQL

I need to keep 2 tables in Sync that exists in both DB's (MySQL running Website, and MS SQL running Backed processing)

Please help

Deon

:)

Wednesday, December 28, 2016 2:14 PM

Answers

0

Sign in to vote
Hello,

We have SQL Azure Data Sync but it is not designed to work with MySQL. The following thread may give you a few ideas on how to do it without the help of SQL Azure Data Sync.

https://social.msdn.microsoft.com/Forums/en-US/520a894a-fcff-4772-93e6-747c66dc8887/sql-data-sync-between-mysql-and-sql-azure?forum=ssdsgetstarted

The following software seems to provide sync capability between SQL Azure databases and MySQL but I have not tested it and it is not free.

https://convertdb.com/mysql/azure

Hope this helps.

Regards,

Alberto Morillo
SQLCoffee.com
- Edited by Alberto MorilloMVP Wednesday, December 28, 2016 7:04 PM
- Proposed as answer by Dan Rediske Thursday, January 5, 2017 7:55 PM
- Marked as answer by Dan Rediske Friday, January 6, 2017 10:56 PM
Wednesday, December 28, 2016 7:04 PM