Post reply

Linked Server Replication

  • March 13, 2013 at 2:44 am

    #290800

    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

    #1596472

    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

    #1596558

    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

    #1596943

    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

    #1596963

    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