March 13, 2013 at 2:44 am
Good Morning
I have been struggling with data synchronization between SQL SERVER and MYSQL for ages, I have tried all possible scenario and cannot get it to work. Added triggers to SQL SERVER with errors. I am now at the point to sync data through REPLICATION but also picked up an issue now. I created the Linked server and it works 100% - Server Options setup as Subscriber, but when I setup new Subscription I cannot see it in the list of databases. What am I missing?
Thanks
March 13, 2013 at 6:51 am
Ok I cannot find anything for this anywhere online, does anyone know of any way for me to SYNC my data from SQL SERVER to MYSQL? I have tried 3rd party programs but it takes a lot of the realtime data replication away
Thanks
March 13, 2013 at 8:57 am
I am certainly no expert in MySQL, but can't you just have some MySQL jobs pull the data using ODBC to SQL Server?
Jared
CE - Microsoft
March 14, 2013 at 5:52 am
Hi
It does make sense to do that, sorry for this silly question but how do I create jobs in mysql? I know how to do it on SQL SERVER through the Management Studio, but no idea how to do it for mysql. I have MYSQL Workbench but don't see that on there or am I looking at this the wrong way?
Thanks
March 14, 2013 at 6:47 am
Well... I don't use MySQL anymore, but a quick google search found this http://www.sitepoint.com/how-to-create-mysql-events/
Jared
CE - Microsoft
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy