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

Database Synchronization Wizard: Definition mismatch for ‘bigint’ column

forums forums SQLyog Sync tools, Migration, Scheduled Backup and Notifications Database Synchronization Wizard: Definition mismatch for ‘bigint’ column

  • This topic is empty.
Viewing 0 reply threads
  • Author
    Posts
    • #36389
      dorje77
      Participant

      Hi,
      I’m trying to sync two identical databases, but the first one is hosted on mysql engine, the other one on mariadb.

      On some tables I theses errors:

      Definition mismatch for ‘bigint’ column
      or
      Definition mismatch for ‘int’ column

      It seems that mysql and mariadb use not fully compatible datatypes and that is preventing SQLyog to sync data (even if data itself would be migrated without issues because are the same type).

      Is there a way to force SLQyog to ignore that differences and sync anyway?
      Or another type of workaround?

      Thank you!

Viewing 0 reply threads
  • You must be logged in to reply to this topic.