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

Sja And Atomic Transaction

forums › forums › SQLyog › Sync tools, Migration, Scheduled Backup and Notifications › Sja And Atomic Transaction

  • This topic is empty.
Viewing 2 reply threads
  • Author
    Posts
    • September 13, 2006 at 9:21 am #9869
      MuphoOx
      Member

      Hi all,

      In my case i have to synchronize 2 distant MySQL databases, i've made the adequate XML files, and what i want to do is to ROLLBACK the transaction if there is any problem during the sync, i used the “Abort on error” function, it work pretty good, but the biggest problem is that if there is any problem the previous changes happened in the beginning of the sync are kept… so we will have 2 databases not correctly synchronized … a very big problem ! could you help me please; it's verry urgent.

      MuphoOx :ph34r:

    • September 13, 2006 at 9:34 am #22409
      MuphoOx
      Member

      Thx to peter laursen, the answer was as brief as i'de liked to !

      SJA does not support transactions!

      🙁 i have a very big problem then …

      any one could help ?

    • September 13, 2006 at 1:15 pm #22410
      peterlaursen
      Participant

      you can repeat the sync over and over again.

      But please understand that synchronisations is not replication!

      And understand the use of the Primary Key: source will overwrite target for the rows where the PK is identical!

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