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

ODBC DataExchangeLink? (Newbie)

forums › forums › SQLyog › Using SQLyog › ODBC DataExchangeLink? (Newbie)

  • This topic is empty.
Viewing 1 reply thread
  • Author
    Posts
    • May 14, 2003 at 11:10 am #7933
      cvsomm
      Member

      Hi there,

      I'm a newbie and looking for a way not to staticly import data via ODBC but to establish a 2way link between MySQL and another source (Filemaker) via ODBC, such as that changes in one database are reflected in the other.

      Is there any way to do this???

      Thanx for any help,

      Chris

    • May 14, 2003 at 1:07 pm #14278
      CalEvans
      Member

      Not without writing a program that sits and watches both databases and compares them at regular intervals.

      2-way replication is very tricky because you have to deal with issues like what if the same record is changed in both databases; who wins?

      I'm not familiar with Filemaker but if it has it's own language and can read and write ODBC sources, your best bet may be to write a program in Filemaker to watch itself and update MySQL when necessary.

      HTH,

      =C=

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