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

Multiple SJA Questions

forums › forums › SQLyog › Sync tools, Migration, Scheduled Backup and Notifications › Multiple SJA Questions

  • This topic is empty.
Viewing 2 reply threads
  • Author
    Posts
    • February 24, 2004 at 10:46 pm #8345
      paulm
      Member

      I would like to use SJA to perform database synchronization between two MySQL databases. One database is on a remote PC. The other database is on a Linux server. Both databases have the same structure. New students records can be added to the student table from both the server and the PC. The primary key for the student table is StudentID. The StudentID is an auto-incrementing field.

      How should I set up SJA to accomplish the synchronization?

      How would SJA handle an ambiguous StudentID while performing a synchronization?

      Thank You,

      Paul

    • March 1, 2004 at 7:54 pm #15514
      paulm
      Member

      At this time SJA only permits synchronization in one direction.

    • March 10, 2004 at 3:09 pm #15515
      Shadow
      Member

      You can set up two jobs to tackle mutual synchronization. SJA does not perform any checks on the PKs.

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