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

Odbc Syncing With Mysql?

forums › forums › SQLyog › Sync tools, Migration, Scheduled Backup and Notifications › Odbc Syncing With Mysql?

Tagged: ,

  • This topic is empty.
Viewing 1 reply thread
  • Author
    Posts
    • August 18, 2014 at 2:35 pm #13250
      sumdingfishy
      Member

      This is possible?  I have a Pervasive SQL Database that uses ODBC to connect with.

       

      The database synchronization tool does not show “ODBC” as a connection source.  

       

      I can run a scheduler for every 1 minute with import external data tool using ODBC to MySQL but it seems that it imports all of the records instead of just importing the rows changed.  Is there anyway around this?

       

      Any suggestions would be great

    • August 19, 2014 at 7:33 am #35019
      peterlaursen
      Participant

      Data Sync in SQLyog only works with MySQL as both source and target. You can sync content of one MySQL database with another MySQL database (on same or different servers).

       

      We also have an ‘import external data’ tool (also from the ‘powertools’ menu) making use of ODBC. It has a lot of settings and it may be useful for your needs. You can INSERT new data rows into MySQL and UPDATE existing ones based on what happens on the ODBC source.  But DELETE from the MySQL target is not possible with this tool.

       

      The documentation has a lengthy paragraph on the ‘import external data’ tool.  Find it in help .. help -menu or online here: 

      https://www.webyog.com/webyog/sqlyogDocs

  • Author
    Posts
Viewing 1 reply thread
  • You must be logged in to reply to this topic.