Unsupported Screen Size: The viewport size is too small for the theme to render properly.

MS Access to mySQL synchronization

forums › forums › SQLyog › Sync tools, Migration, Scheduled Backup and Notifications › MS Access to mySQL synchronization

  • This topic is empty.
Viewing 2 reply threads
  • Author
    Posts
    • January 31, 2005 at 3:05 pm #8765
      chris123
      Member

      Hello. I am trying to set-up an automated synchronization (event driven or scheduled) between MS Access (source) and MySQL (target) databases. Is SQLyog able to do this, or do I need to include other tools?

      The systems are remote to each other and the data would be flowing across the internet (could look towards VPN if absolutely necessary). mySQL is running on win2000.

      Thanks in advance for any comments/suggestions.

      -Chris

      P.S. I love the new features well worth the $79!

    • January 31, 2005 at 4:17 pm #16918
      Ritesh
      Member

      Currently you can only sync 2 MySQL databases using SQLyog and SQLyog Job Agent.

      Scheduled ODBC Import is planned for SQLyog v4.1.

      As of now, you will need to import data from MS Access db manually using SQLyog's ODBC Import Tool.

    • January 31, 2005 at 6:51 pm #16919
      chris123
      Member

      Thanks. It looks like there are a couple of tools out there that can help (Access-MySQL Converter & also Access2MySQL).

      -Chris

  • Author
    Posts
Viewing 2 reply threads
  • You must be logged in to reply to this topic.